Sql

Question

Select all employee detail with First name VikasAshish and Nikhil.

Debendra Dash · Answer

Select * from employee where FirstName in ( 'Vikas''Ashish''Nikhil')

Rakesh · Answer

command : select * from table where columnName in ('vikesh''ashish''nikhil') select * from employee where FirstName in ('vikesh''ashish''nikhil')

Upendra Pratap Shahi · Answer

select * from Employee where FirstName like '[VAN]%' [in this put your search first letter]

Upendra Pratap Shahi · Answer

select * from Employee where FirstName in('Vikas''Ashish' 'Nikhil')

Pankaj Kumar Choudhary · Answer

Select * from employee where FirstName in ( 'Vikas''Ashish''Nikhil')

Munesh Sharma · Answer

Select * from employee where FirstName in ( 'Vikas''Ashish''Nikhil')

Rajeesh Menoth · Answer

Hi What's your problem Alok Gupta  can you explain more ? Like this : select * from Employee where FirstName in('Vikas''Ashish' 'Nikhil') Ref more : http://www.scribd.com/doc/260012950/SQL-Server-Interview-Questions-Queries-by-Vikas-Ahlawat#scribd