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 votes162 views1 answer
Mysql how to store lat,lng
SQL
25 votes192 views6 answers
How to change column name in mysql
SQL
2 votes159 views1 answer
Oracle sql day of month from date
SQL
0 vote156 views1 answer
Excute raw query
SQL
0 vote173 views1 answer
SQL Server modify_timestamp trigger
SQL
1 vote180 views1 answer
Oracle sql first day of year
SQL
0 vote179 views1 answer
Alter table change default
SQL
41 votes254 views6 answers
Alter table add column in SQL Server
SQL
0 vote175 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote175 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL