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 vote320 views1 answer
SQL Server modify_timestamp trigger
SQL
15 votes329 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote340 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote357 views1 answer
Updating database in sql
SQL
0 vote370 views1 answer
Implode in sql query
SQL
1 vote347 views1 answer
Sql order by where condition
SQL
1 vote363 views2 answers
Maximum number of tables in mysql
SQL
0 vote344 views1 answer
How to check event scheduler status mysql
SQL
0 vote331 views1 answer
Sql comand for removing data from table
SQL
1 vote324 views1 answer
Flask sqlalchemy filter multiple conditions
SQL