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 vote180 views1 answer
Check if a word appears at the end sql query
SQL
12 votes185 views2 answers
Delete all data in neo4j
SQL
1 vote196 views1 answer
Get table column names sql ssms
SQL
0 vote186 views2 answers
Avg() sql
SQL
1 vote182 views1 answer
Oracle convert run duration to number
SQL
-3 votes189 views1 answer
Remove spaces sql 2008
SQL
0 vote180 views1 answer
How to update random rows in sql
SQL
10 votes207 views2 answers
Sql pagination offset
SQL
0 vote226 views1 answer
Traccar mysql
SQL
1 vote198 views1 answer
Mysql best tutorial for beginners
SQL