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 vote161 views2 answers
Sql server select first day of previous year
SQL
-1 vote141 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote164 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
1 vote204 views1 answer
Oracle select first row order by
SQL
0 vote276 views1 answer
How to use select union and loop
SQL
0 vote190 views1 answer
Oracle swap partition
SQL
3 votes151 views1 answer
Oracle APEX elapsed time
SQL
0 vote153 views1 answer
What is logical database schema
SQL
21 votes126 views7 answers
Table drop if exist sql server
SQL
-1 vote171 views1 answer
Module operator in oracle sql
SQL