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 vote139 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote151 views1 answer
Mariadb alter table add column if not exists example
SQL
-1 vote150 views4 answers
Restart mysql server ubuntu
SQL
0 vote131 views1 answer
Postgresql create user roles
SQL
0 vote144 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
1 vote142 views1 answer
Restart identity postgresql
SQL
2 votes146 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
1 vote137 views3 answers
Getdate function in postgresql
SQL
0 vote138 views1 answer
Sql composite key
SQL
1 vote281 views1 answer
Sql check roles
SQL