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

1 vote228 views1 answer
DATE_SUB postgres
SQL
0 vote277 views1 answer
How to find unique element in sql
SQL
0 vote229 views1 answer
Show database not empty tables postgres
SQL
0 vote442 views1 answer
Power bi connect to postgresql
SQL
-1 vote239 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote232 views1 answer
Mysql in clausule string array
SQL
0 vote210 views1 answer
Output to file mysql
SQL
4 votes230 views2 answers
Sql offset
SQL
0 vote218 views1 answer
Sql server whoami
SQL
0 vote240 views1 answer
How we can perform acid Operations in sql with examples
SQL