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

2 votes127 views1 answer
Python sql
SQL
0 vote94 views1 answer
Suse start MySQL
SQL
0 vote101 views1 answer
Mysql select inside sum
SQL
-1 vote101 views1 answer
Export mysql table to file
SQL
19 votes95 views6 answers
Sql create table
SQL
0 vote104 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote113 views1 answer
Mysql exception output
SQL
0 vote146 views1 answer
Placements hackerrank solution
SQL
3 votes95 views1 answer
What is having clause
SQL
1 vote123 views1 answer
Oracle grant select on schema
SQL