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

2 votes174 views3 answers
Application.properties spring boot mysql
SQL
0 vote175 views1 answer
Restore backupfile discourse
SQL
8 votes179 views2 answers
Mysql get first x characters
SQL
0 vote194 views1 answer
Dockerfile example for Django
SQL
5 votes188 views3 answers
Sql max value in column
SQL
0 vote178 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote161 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
1 vote172 views1 answer
How to see all table partition in oracle
SQL
0 vote227 views3 answers
Mysql CAST(amount as float)
SQL
1 vote194 views3 answers
Divide by zero error in sql
SQL