Easy
Given the following 'products' table:
| product_id | name | price |
|------------|----------|-------|
| 1 | Laptop | 1200 |
| 2 | Tablet | 600 |
| 3 | Monitor | 300 |
Which SQL query retrieves the products with a price less than 1000 and sorts the results in descending order of price?
Author: Vincent CotroStatus: PublishedQuestion passed 2625 times
Edit
10
Community EvaluationsNo one has reviewed this question yet, be the first!
16
Update a column in an SQL table11
Write the SQL query to delete a column from a table16
Which SQL keyword is used to sort the result of a SELECT statement?11
How to delete an SQL table?17
Write a SQL query to insert data into a table19
Select only distinct values in a column using SQL41
Write a SQL query to retrieve the list of employees with a salary greater than 5100.