title: MS Access: show only the max and min row using SQL
body: <p>I have a little Problem with sql again :)
  In this example I have to show the max ekpreis in one row and the min ekpreis in a second row. But with all the other data aswell. I tried select max(ekpreis) but that didnt worked.</p>
  
  <p><img src="https://i.stack.imgur.com/DSyLS.jpg" alt="enter image description here"></p>
  
  <p>I tried this:</p>
  
  <p>SELECT ARTBEZ, max(ekpreis)
  FROM artst
  Group by artbez;</p>
  
  <p>But this just returns all the rows and not just the max row.</p>