Sql select min

-- This gives you the customer name and balance for
-- the customer with the lowest balance.

select CustomerName, Balance -- start your query as normal
from Customers
where Balance = ( -- now when specifying where, you do another query
  select MIN(Balance) -- where you select the lowest balance
  from Customers
);

Similar codes

0 vote358 views1 answer
Insert query return id mysql
SQL
1 vote346 views3 answers
Mysql on delete set null
SQL
-2 votes332 views4 answers
How to get max salary in each department in sql
SQL
0 vote335 views1 answer
Sql get latest of 2 datetimes
SQL
4 votes353 views1 answer
What are the data types
SQL
0 vote384 views1 answer
Oracle calculate statistics on partition
SQL
2 votes333 views1 answer
Search query in mysql
SQL
1 vote328 views1 answer
Deleting database in sql
SQL
23 votes336 views6 answers
How to create table in sql
SQL
1 vote311 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL