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

1 vote262 views2 answers
Sql example query
SQL
0 vote227 views1 answer
How to check rollback status in oracle
SQL
0 vote171 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
123 votes1.1K views5 answers
Sql where contains
SQL
2 votes156 views1 answer
Oracle current date without time
SQL
0 vote188 views1 answer
Load utilities in sql server
SQL
18 votes180 views4 answers
Mysql current date between two dates
SQL
0 vote181 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
2 votes235 views3 answers
How to replace null values in sql
SQL
0 vote196 views1 answer
Sql get year from datetime field
SQL