Search
 
SCRIPT & CODE EXAMPLE
 

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);
Comment

PREVIOUS NEXT
Code Example
Sql :: big query get distinct array of objects 
Sql :: convert mongodb to sql 
Sql :: postgres grep entire database 
Sql :: oracle execute package dblink 
Sql :: mysql create user if not exists 
Sql :: how to change the field size of an existing column 
Sql :: sql get latest of 2 datetimes 
Sql :: select from where 
Sql :: from weeknumber to date 
Sql :: sqlite ignore index 
Sql :: compare two tables to find unmatched records 
Sql :: ring close the connection to the database using the odbc_disconnect() 
Sql :: ora 00001 error catch plsql 
Sql :: oracle grant alter table constraint 
Sql :: How to get number of months between 2 dates sql server 
Sql :: while in plsql 
Sql :: how to run sql query in mysql workbench 
Sql :: multiple values insert in sql 
Sql :: parsing float to int in mysql 
Sql :: mysql match in serialized data 
Sql :: criteria builder select subset of column 
Csharp :: ms crm set state request dynamics 365 set state request 
Csharp :: c# sleep 
Csharp :: how to detect mouse click in c# 
Csharp :: bitmasking in c# 
Csharp :: how to call something once in update 
Csharp :: how to clear console in c# 
Csharp :: how to change the color of your text in c# 
Csharp :: unity check if key pressed 
Csharp :: convert timestamp to datetime c# code 
ADD CONTENT
Topic
Content
Source link
Name
3+8 =