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 vote155 views3 answers
Sql delete all except
SQL
1 vote147 views1 answer
Drop function
SQL
0 vote160 views1 answer
Oracle show grants on table
SQL
0 vote191 views1 answer
Cannot start database server xampp mac os
SQL
0 vote140 views1 answer
Csv to sqlite python
SQL
0 vote151 views1 answer
Resullt all update knex mysql
SQL
3 votes155 views2 answers
Tsql join multiple record in one string
SQL
1 vote166 views1 answer
How to delay stored procedure execution in sql server
SQL
2 votes214 views2 answers
How to DROP a table in mysql
SQL
0 vote169 views1 answer
MySQL import data from large CSV file
SQL