SQL Interview Questions | Pay Raise
Question
| NAME | SALARY | Date of Joining |
| Angad | 50,000 | 05 July |
| Bhuvan | 52,000 | 19 March |
| Danish | 77,000 | 06 September |
| Manhar | 64,000 | 15 May |
| Shivraj | 50,000 | 10 July |
| Tanuj | 55,000 | 13 August |
You are supposed to provide a salary raise to the employees who have joined after the 31 June. Collect the names of the employees who satisfy the condition.
in progress
1
SQL
4 years
7 Answers
2013 views
Great Grand Master 0
Answers ( 7 )
Select name from table where date of joining> June 31
select name from employee where month(DateJoining) > 6
select name from employee where month(DOJ)>’6′;
select Name from Employee
where month(Date of Joining)>6;
select name from employee where month(Date of Joining) > 6
SELECT NAME FROM EMPLOYEES
WHERE EXTRACT(MONTH FROM JOINING_DATE) > 6
select name from employees where month(Date Of Joining)>6;