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 vote300 views1 answer
Ms sql print more than 1 variable
SQL
0 vote312 views2 answers
Postgresql could not start server mac
SQL
0 vote686 views1 answer
Power bi connect to postgresql
SQL
5 votes363 views1 answer
Oracle sysdate - 1 month
SQL
0 vote373 views1 answer
Renombrar tabla mysql
SQL
7 votes374 views6 answers
Mysql group concat
SQL
1 vote397 views1 answer
Last 24 HOUR data in mysql
SQL
1 vote355 views1 answer
Moodle query item quiz
SQL
7 votes341 views3 answers
Sql get last inserted row
SQL
1 vote370 views2 answers
Postgresql truncate cascade restart identity
SQL