title: How to use aggregate function without GROUP BY?
body: <pre><code>SQL&gt; SELECT * FROM student;
  NAME                 ID                AGE      MARK1      MARK2      TOTAL   
  -------------------- ---------- ---------- ---------- ---------- -----------
  Ananda               200                22         90         95
  Chris                250                18         80         75
  Gokul                325                17         50         50
  
  SQL&gt; SELECT MAX(mark1),name FROM student;
  SELECT MAX(mark1),name FROM student
                    *
  ERROR at line 1:
  ORA-00937: not a single-group group function
  </code></pre>
  
  <p>As you can see the error,
  can anyone suggest me a query to select the Maximum mark from the table
  and display it along with the corresponding name of the student??</p>
  
  <p>Is it even possible without using GROUP BY clause?
  As you can see, there's no logical way of using GROUP BY clause here.</p>