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 2609 times
Edit
36
Community EvaluationsNo one has reviewed this question yet, be the first!
14
Which SQL keyword is used to sort the result of a SELECT statement?17
Select only distinct values in a column using SQL9
Write a SQL query to retrieve the titles of books written by 'John Smith'.15
Write a SQL query to insert data into a table15
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 table