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

26 votes136 views2 answers
What is the sql statement that finds duplicate usernames
SQL
1 vote156 views1 answer
Oracle user last connection date
SQL
11 votes136 views1 answer
Ddl materialized view
SQL
2 votes135 views1 answer
Alter table add multiple columns postgresql
SQL
16 votes147 views3 answers
Jwt secret key generator laravel
SQL
0 vote164 views1 answer
When mysql server would not work in xampp
SQL
1 vote132 views3 answers
How to truncate foreign key constraint table
SQL
5 votes142 views1 answer
Commentaire table oracle
SQL
3 votes155 views2 answers
Sqlite show table definition
SQL
0 vote158 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL