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

2 votes233 views2 answers
How to rename column name in sql server using query
SQL
0 vote262 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote215 views1 answer
Hallo
SQL
0 vote296 views1 answer
Drop table BigQuery table columns
SQL
27 votes247 views3 answers
Mysql show tables in database
SQL
0 vote240 views1 answer
How to add boolean column in postgresql
SQL
16 votes262 views6 answers
Mysql find duplicates in same table
SQL
2 votes258 views1 answer
Sql find not in list
SQL
7 votes244 views2 answers
Sql empty table
SQL
2 votes269 views3 answers
Row number mysql
SQL