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
1697 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