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 vote323 views1 answer
Get employees if not contains in sql
SQL
3 votes322 views1 answer
How to uninstall microsoft sql server
SQL
0 vote325 views1 answer
SQL loop with cursor
SQL
0 vote330 views1 answer
Lost connection to mysql
SQL
6 votes332 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote339 views1 answer
SQL query to get all table records count from a database
SQL
1 vote321 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote310 views1 answer
Postgres regex remove special characters
SQL
7 votes315 views3 answers
How to check table name in current database sql
SQL
4 votes344 views3 answers
Sql drop database if exists
SQL