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 vote349 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote357 views2 answers
Search stored procedures by name
SQL
0 vote333 views1 answer
Flask sqlalchemy update row
SQL
1 vote403 views1 answer
Import sql file from laravel
SQL
0 vote361 views1 answer
In query in sql
SQL
0 vote334 views1 answer
Get created time of database psql 8
SQL
0 vote304 views8 answers
Convert sql query to linq online
SQL
7 votes401 views3 answers
Sql server check if temp table exists
SQL
7 votes367 views3 answers
Python and mysql connectivity
SQL
-2 votes328 views2 answers
Sqlserver docker
SQL