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 vote263 views1 answer
Sql alter table order by
SQL
0 vote277 views1 answer
Oracle locked objects
SQL
3 votes279 views1 answer
Postgresql if null then 0
SQL
16 votes315 views1 answer
Mysql mediumint max value
SQL
1 vote240 views1 answer
Delete triger pl pg sql
SQL
0 vote293 views1 answer
Check if mysql db is used
SQL
12 votes259 views1 answer
Docker run mysql image
SQL
0 vote283 views1 answer
Sql max of two values
SQL
3 votes279 views1 answer
DB: in eloquent using sql
SQL
0 vote284 views1 answer
Openquery join two tables
SQL