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 vote297 views1 answer
Postgresql datetrunc too slow
SQL
3 votes256 views1 answer
If 0 return null else return query mysql
SQL
0 vote300 views1 answer
Sql count matching group by
SQL
0 vote298 views1 answer
Mysql filter based on datediff
SQL
1 vote309 views1 answer
Oracle datafile max size 32gb
SQL
1 vote301 views1 answer
Sql server kill all connections
SQL
0 vote276 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote314 views1 answer
Sql filter rows with condition
SQL
0 vote379 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote293 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL