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 vote110 views1 answer
Firebase sql
SQL
2 votes110 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
8 votes121 views1 answer
Oracle search text in all packages
SQL
21 votes111 views3 answers
Sql server search column name in all tables
SQL
0 vote119 views1 answer
Sqlite3_open_v2
SQL
1 vote183 views1 answer
Oracle create program if not exists
SQL
0 vote118 views2 answers
Dumping sql table
SQL
0 vote69 views1 answer
Import csv to mysql
SQL
14 votes114 views4 answers
Sql compiler
SQL
0 vote105 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL