Which SQL keyword is used to retrieve a maximum value?

 Posted by CGN007 on 6/14/2012 | Category: Sql Server Interview questions | Views: 5873 | Points: 40
Select from following answers:
  1. TOP
  2. MAX
  3. SUM
  4. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Gemamgall on: 6/27/2012 | Points: 10
MAX is keyword used to retrieve maximum value
Posted by: Krishnamsai on: 5/20/2013 | Points: 10
The Max() Function returns the largest value of the selected column.

examples: SELECT MAX (column_name) FROM Table_name;
SELECT MAX (price) AS Highest Price FROM Products;

Login to post response