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 vote215 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote231 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote233 views1 answer
Stored procedures example
SQL
0 vote228 views1 answer
Sql drop procedure if exists
SQL
5 votes227 views1 answer
Invalid column name sql
SQL
4 votes212 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote169 views2 answers
Denormalization in sql
SQL
1 vote227 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
4 votes217 views3 answers
Copy table postgres
SQL
1 vote219 views1 answer
Incompatible sql_mode=only_full_group_by
SQL