Sql

SELECT * FROM payment
WHERE amount = (
 	SELECT
  	   MAX(amount)
	FROM
	   payment
);

SELECT  id, first_name, last_name, grade
FROM student
WHERE grade = (SELECT MAX(grade) FROM student);

PREVIOUS	NEXT

Code Example
Sql :: disable trigger sql oracle
Sql :: postgres set default value
Sql :: psql while loop
Sql :: mysql columns values as comma separated string
Sql :: Get Minimum from multiple columns sql
Sql :: check if record exists mysql
Sql :: mysql date time string format python
Sql :: how to get id of last inserted row in mysql
Sql :: temp table sql
Sql :: round one decimal place mysql
Sql :: execute mysql file
Sql :: SQLSTATE[IMSSP]: The active result for the query contains no fields.
Sql :: how to get duplicate records with multiple field in sql
Sql :: remove duplicates sql server select
Sql :: reseed sql table primary key
Sql :: sql server concat string and int
Sql :: ignore case like sql
Sql :: mysql add column with default value
Sql :: oracle desc table primary key
Sql :: mysql cashing error
Sql :: postgres concat
Sql :: error code 1451 sql
Sql :: store select query result in variable sql server
Sql :: sql get month from date
Sql :: sql pagination oracle
Sql :: mysql date range
Sql :: write sql query to find the second highest salary of employee
Sql :: sql table
Sql :: postgres regular expression replace
Sql :: sql server datetime to string