We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Select
- Employee Salaries
- Discussions
Employee Salaries
Employee Salaries
Sort by
recency
|
1068 Discussions
|
Please Login in order to post a comment
Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than per month who have been employees for less than months. Sort your result by ascending employee_id.
Input Format
The Employee table containing employee data for a company is described as follows:
This query was really helpful! It’s great to quickly find employees with higher salaries and shorter tenure, sorted by their ID. Managing employee data efficiently is crucial, just like how the https://essutumishiportal.co.tz/ simplifies salary management for Tanzanian public service workers.
SELECT NAME FROM EMPLOYEE WHERE SALARY >2000 AND MONTHS<10 ORDER BY EMPLOYEE_ID ASC;
SELECT name FROM Employee WHERE salary > 2000 AND months < 10 ORDER BY employee_id ASC;
MySQL:
SELECT name FROM Employee WHERE salary > 2000 AND months < 10 ORDER BY employee_id ASC