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
|
893 Discussions
|
Please Login in order to post a comment
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
select name from employee where salary >= 2000 and months <= 10 order by employee_id;
but exptected result not match with data
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;