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 vote108 views1 answer
Oracle get running queries
SQL
0 vote93 views1 answer
Is not null postgresql
SQL
3 votes112 views1 answer
Postgres select max value
SQL
19 votes100 views2 answers
Mysql add column after another
SQL
0 vote109 views1 answer
Sql find gaps in date ranges
SQL
0 vote94 views1 answer
Oracle list of long running queries
SQL
2 votes88 views1 answer
Mysql auto increment jumping
SQL
3 votes99 views2 answers
Laravel tosql with bindings
SQL
0 vote97 views1 answer
Mysql user set plugin
SQL
0 vote107 views1 answer
Bigquery declare
SQL