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

10 votes125 views1 answer
Create table oracle
SQL
0 vote120 views1 answer
List mysql tables and views
SQL
0 vote160 views1 answer
C# sql transaction multiple connections
SQL
7 votes142 views2 answers
Sql remove duplicates based on column
SQL
6 votes139 views1 answer
SQL insert all columns
SQL
1 vote322 views2 answers
Coderbyte sql solutions
SQL
0 vote140 views1 answer
Alter check command
SQL
0 vote155 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
2 votes127 views1 answer
Oracle virtual column
SQL
0 vote136 views1 answer
Sql include rows with 0 values
SQL