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 vote315 views1 answer
Implicit inner join table alias
SQL
8 votes312 views2 answers
Select table column name in sql
SQL
1 vote307 views1 answer
Postgresql delete cascade
SQL
4 votes374 views1 answer
Oracle table statistics
SQL
0 vote303 views1 answer
Mysql query problems and solutions
SQL
0 vote327 views1 answer
Mysql config address
SQL
0 vote343 views1 answer
Apt install sql server
SQL
0 vote312 views1 answer
Date on SQL
SQL
0 vote322 views2 answers
Mysql set foreign_key_checks=0
SQL
1 vote304 views3 answers
Sql select only time from datetime
SQL