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 vote194 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote246 views1 answer
For select oracle
SQL
4 votes185 views2 answers
Linq join
SQL
0 vote185 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote204 views1 answer
Sql server size of every table in a db
SQL
3 votes196 views1 answer
Sql cast to integer
SQL
1 vote325 views1 answer
Sql injection
SQL
0 vote193 views1 answer
Set default value now() date
SQL
0 vote239 views1 answer
Get max salary from each department sql
SQL
0 vote191 views1 answer
Sql pivot without aggregate
SQL