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 views1 answer
Postgres format date in select
SQL
0 vote303 views1 answer
Create synonym for dblink in oracle
SQL
3 votes325 views1 answer
Mysql group_concat distinct
SQL
0 vote244 views1 answer
Sql truncate table referencing itself
SQL
0 vote268 views1 answer
C# datetime to sql server datetime
SQL
1 vote289 views2 answers
How to combine 2 tables in MySQL
SQL
5 votes260 views6 answers
Sql add days to date
SQL
0 vote281 views1 answer
Mysql count number of occurrences in a column
SQL
1 vote289 views1 answer
Sql select max value from multiple rows
SQL
1 vote291 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL