Easy
Given the following 'employees' table:
| id | first_name | last_name | salary |
|----|------------|-----------|--------|
| 1 | John | Doe | 5000 |
| 2 | Jane | Smith | 5500 |
| 3 | Alice | Johnson | 5200 |
Which SQL query retrieves the list of employees with a salary greater than 5100?
Author: Vincent CotroStatus: PublishedQuestion passed 2410 times
Edit
33
Community EvaluationsNo one has reviewed this question yet, be the first!
15
Select only distinct values in a column using SQL15
Update a column in an SQL table10
Write a SQL query to retrieve the products with a price less than 1000 and sort the results in descending order of price.10
Write the SQL query to delete a column from a table12
Write a SQL query to insert data into a table12
Which SQL keyword is used to sort the result of a SELECT statement?9
Write a SQL query to retrieve the titles of books written by 'John Smith'.