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 vote193 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote223 views1 answer
Search column name sql
SQL
2 votes222 views3 answers
How to get second highest salary in each department in sql
SQL
7 votes195 views2 answers
Mysql db size
SQL
1 vote217 views2 answers
Remove space in mysql
SQL
1 vote224 views1 answer
Oracle drop temporary table
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
6 votes198 views1 answer
Sqlite foreign key
SQL
0 vote198 views2 answers
Sql searching via key word
SQL
0 vote239 views1 answer
Create function in microsoft sql server
SQL