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 vote312 views4 answers
Fatal database postgres does not exist
SQL
0 vote347 views1 answer
Get schema of table sql
SQL
0 vote316 views1 answer
Update set with join pl sql
SQL
3 votes357 views1 answer
Create a table with an id in mysql
SQL
0 vote329 views1 answer
Tsql default value when no value returned by query
SQL
0 vote339 views1 answer
Update sqlite
SQL
0 vote364 views2 answers
T sql null or empty string
SQL
0 vote335 views1 answer
Mysql update from n to 100
SQL
5 votes333 views3 answers
Oracle list columns in schema
SQL
1 vote290 views1 answer
Postgres grant read only access to database
SQL