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 vote142 views1 answer
Get employees if not contains in sql
SQL
0 vote182 views1 answer
Shortcut run sql pgadmin
SQL
1 vote123 views4 answers
Sql now
SQL
3 votes138 views1 answer
Ms sql skip take
SQL
0 vote147 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote151 views2 answers
How to find max and min salary in sql
SQL
2 votes148 views5 answers
SQL trigger
SQL
1 vote107 views1 answer
Unique vs distinct sql
SQL
0 vote154 views2 answers
Port 5432 is already in use mac
SQL
0 vote134 views1 answer
List mysql tables and views
SQL