Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to write query to to display record having maximum value

SELECT  id, first_name, last_name, grade
FROM student
WHERE grade = (SELECT MAX(grade) FROM student);
Source by learnsql.com #
 
PREVIOUS NEXT
Tagged: #write #query #display #record #maximum
ADD COMMENT
Topic
Name
7+2 =