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
Dhruv2301 4 days 3 Answers 46 views Contributor 0

Answers ( 3 )

    0

    Select name from table where date of joining> June 31

  1. select name from employee where month(DateJoining) > 6

  2. select name from employee where month(DOJ)>’6′;

Leave an answer

Browse
Browse