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

1 vote292 views1 answer
Nvl postgres
SQL
0 vote213 views1 answer
Oracle sysdba connect as another user
SQL
0 vote256 views1 answer
Mssql check if date is greater than today
SQL
1 vote252 views1 answer
Postgres get month name from date
SQL
6 votes309 views2 answers
Oracle compile trigger
SQL
3 votes249 views1 answer
Sql datetime as date
SQL
0 vote250 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
1 vote268 views1 answer
Where to locate set password for mysql
SQL
0 vote201 views1 answer
Microsoft sql server management studio clear cache
SQL
1 vote252 views2 answers
String to date postgres
SQL