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 vote179 views1 answer
Drop database using terminal postgres
SQL
0 vote171 views1 answer
Sql server isnull function nor working count
SQL
1 vote207 views1 answer
Mysql previous year
SQL
0 vote170 views1 answer
Alter table fulltext
SQL
1 vote161 views2 answers
Mysql update table from another table
SQL
0 vote189 views1 answer
Why do we need data structure in sql
SQL
0 vote166 views1 answer
2020 new year
SQL
1 vote124 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote184 views1 answer
Pgadmin save data greyed out
SQL
4 votes201 views1 answer
What are the data types
SQL