Select from following answers:- SELECT * FROM Employee WHERE LastName LIKE 'D%' OR LastName LIKE 'E%' OR LastName LIKE 'F%' OR LastName LIKE 'G%'
- SELECT * FROM Employee WHERE LastName LIKE '[D-G]%'
- SELECT * FROM Employee WHERE LastName LIKE '%[D-G]'
- 1 or 2
- All Above
In SQL Server (lastName LIKE '[A-B]%') condition is equivalent to the following multi-condition
(lastName LIKE 'A%' OR lastName LIKE 'B%')
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator