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
SQL
4 years
7 Answers
1501 views
Great Grand Master 0
Answers ( 7 )
select * from Employee where Name LIKE ‘[^c-r]%’
select * from emmployees where Name like ‘[!c-r]%’
select * from Employee where Name LIKE ‘^[^c-r]%’
select *from Employees where Name like ‘[^ C-R]%’
select * from Employee where Name LIKE ‘[^c-r]%’
SELECT *
FROM EMPLOYEE
WHERE NAME NOT LIKE ‘[c-r]%’
Is this in SQL server> soesnt seem to work in mySQL