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 vote216 views1 answer
Oracle execute immediate quotes
SQL
0 vote202 views1 answer
Mod function example
SQL
4 votes197 views2 answers
Tsql utf to local time
SQL
-1 vote261 views1 answer
MYSQL stored procedure select from
SQL
25 votes247 views6 answers
Import database mysql command line
SQL
0 vote211 views1 answer
Primary key multiple
SQL
0 vote337 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote202 views1 answer
How to move a columns location in mysql
SQL
-1 vote235 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
22 votes201 views4 answers
Show list of users in mysql
SQL