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 vote197 views1 answer
Sql cnvert bit to nvarchar
SQL
11 votes194 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote212 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote178 views1 answer
Install mysql for fedora 34
SQL
0 vote188 views1 answer
Mysql DDL
SQL
1 vote368 views2 answers
Sql unique rows
SQL
3 votes182 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote196 views1 answer
Column ' ' in field list is ambiguous
SQL
6 votes243 views2 answers
Install psql mac
SQL
0 vote190 views1 answer
Cannot pip install mysqlclient
SQL