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

6 votes272 views3 answers
Mysql first day of year
SQL
24 votes243 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote304 views2 answers
While mysql
SQL
0 vote270 views1 answer
How to connect to mysql in ef 6
SQL
0 vote271 views1 answer
Sql count null as 0
SQL
0 vote287 views1 answer
Oracle sql drop table
SQL
0 vote284 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
14 votes295 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
-1 vote311 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
5 votes265 views2 answers
Oracle to_timestamp
SQL