SQL Interview Questions | Employee Details

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

 

Get the details of the employees whose “FirstName” does not start with any of the characters between ‘c-r’

in progress 0
Dhruv2301 4 days 3 Answers 35 views Contributor 0

Answers ( 3 )

  1. select * from Employee where Name LIKE ‘[^c-r]%’

  2. select * from emmployees where Name like ‘[!c-r]%’

  3. select * from Employee where Name LIKE ‘^[^c-r]%’

Leave an answer

Browse
Browse