DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
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
COMMENT
Name
7+2 =
Submit