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

5 votes149 views1 answer
Oracle asynchronous update
SQL
3 votes131 views1 answer
Select without null values sql
SQL
1 vote133 views1 answer
Oracle split string
SQL
0 vote162 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
-1 vote147 views1 answer
Module operator in oracle sql
SQL
4 votes150 views1 answer
Adding data to table in sql python
SQL
0 vote136 views1 answer
Mysql find non alphanumeric characters
SQL
2 votes131 views1 answer
Scaffold npgsql net core
SQL
6 votes140 views1 answer
Update left join mysql
SQL
0 vote99 views1 answer
Select all domains of database firbird
SQL