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 vote161 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote143 views1 answer
Oracle last character of string
SQL
3 votes150 views1 answer
How to check schema privileges in oracle
SQL
0 vote147 views1 answer
Can we rollback deleted data in sql
SQL
5 votes120 views1 answer
Alter table default value mysql
SQL
8 votes205 views1 answer
Insert a select statement into a table
SQL
0 vote218 views2 answers
Fanyi
SQL
0 vote148 views1 answer
SQL loop with cursor
SQL
1 vote147 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote135 views1 answer
Dasebase_url-postgres for windows
SQL