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 vote362 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote381 views1 answer
Sql change column in existing table
SQL
0 vote394 views1 answer
Sql multiple into
SQL
0 vote365 views1 answer
Oracle list partitions
SQL
0 vote353 views1 answer
Insert thai language sql server
SQL
4 votes336 views1 answer
Wilayah indonesia database
SQL
0 vote352 views1 answer
Sql delete row from table where id
SQL
5 votes354 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
1 vote348 views1 answer
Oracle rolling back
SQL
1 vote359 views1 answer
Select tables with name like mysql
SQL