Answers for "sql select where min value is"

SQL
0

select minimum value sql

/*this return only one row with the minimum value stored of your_column*/
select min(your_column) 
  from your_table;
Posted by: Guest on May-26-2021
0

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
);
Posted by: Guest on April-11-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language