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 vote245 views1 answer
Hallo
SQL
1 vote277 views1 answer
Rows to comma separated values in mssql
SQL
-1 vote288 views2 answers
Sql truncate number
SQL
2 votes282 views1 answer
Mysql now format
SQL
0 vote272 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote284 views1 answer
Postgres grep entire database
SQL
2 votes304 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote276 views1 answer
Sql server set complex constraints
SQL
22 votes349 views1 answer
Mysql workbench
SQL
12 votes294 views5 answers
Rename table in mysql
SQL