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 vote128 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote132 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote133 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote129 views1 answer
Copy Table from SQL to CSV
SQL
2 votes130 views1 answer
Oracle drop table free up space
SQL
0 vote137 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote125 views1 answer
Mysql check if string contains comma separated
SQL
0 vote127 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote147 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote134 views1 answer
Postgres meta command to show all rows in table
SQL