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 vote124 views1 answer
Join to find results not in another table
SQL
0 vote114 views1 answer
Insert or update cassandra
SQL
1 vote119 views1 answer
Rails run native ssql query
SQL
0 vote125 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
1 vote142 views1 answer
Oracle grant select on schema
SQL
-1 vote154 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote154 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote144 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
5 votes121 views1 answer
Oracle list packages
SQL
1 vote118 views1 answer
Incompatible sql_mode=only_full_group_by
SQL