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 vote209 views1 answer
How to query without duplicate rows in sql
SQL
4 votes210 views1 answer
Refresh postgres config
SQL
0 vote206 views1 answer
Find all tables where column name exists oracle
SQL
1 vote210 views1 answer
Postgres set column based on another column
SQL
1 vote224 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
8 votes223 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote204 views1 answer
Get url of cpanel database hostname
SQL
0 vote199 views2 answers
What is 1=2 in sql
SQL
2 votes203 views2 answers
Postgres drop column if exists
SQL
1 vote201 views1 answer
Oracle list datafiles in tablespace
SQL