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 vote151 views1 answer
Mysql where sum > 0
SQL
0 vote126 views1 answer
Alter table myisam to innodb
SQL
1 vote146 views2 answers
Mysql extract number from string
SQL
0 vote117 views1 answer
Mysql cdn link
SQL
0 vote136 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote140 views1 answer
Sql server current time without date
SQL
0 vote124 views1 answer
How to see the query of a view in mysql
SQL
0 vote173 views1 answer
Sql alter table add column if exists
SQL
5 votes114 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote124 views1 answer
Low level operator in dbms
SQL