Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

Answers were Sorted based on User's Feedback



in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / muthu kumar

select * from emp where empname like '%j%'

Is This Answer Correct ?    12 Yes 1 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / ashok

select * from Emp where name like '%j%'

Is This Answer Correct ?    7 Yes 1 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / kalpana

select * from emp where name like '%J%'

Is This Answer Correct ?    5 Yes 1 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / deepa

For those who names starts with letter J is

select * from emp where name like 'j%'

For those who names with letter J is

select * from emp where name like '%j%'

Is This Answer Correct ?    2 Yes 3 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / faridha

select * from emp where ename like 'J%' or '%J' and
not like ('arjun','jagadesh','niranjan','anju','aaaj');

Is This Answer Correct ?    0 Yes 1 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / ashok

select * from employee where name like=%'j'%

Thanx
Ashok

Is This Answer Correct ?    1 Yes 7 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / nithya_raghu

select * from emp where empname like J%

Is This Answer Correct ?    0 Yes 7 No

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jaga..

Answer / ashok

select * from employee where name like=%'j'%

Thanx
Ashok

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More SQL Server Interview Questions

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,


What is the difference between seek predicate and predicate?

0 Answers  


What does it mean to be in union?

0 Answers  


Can we call stored procedure in view in sql server?

0 Answers  


Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

0 Answers  


What is the use of for clause?

0 Answers  


What are the different SQL Server Versions you have worked on?

0 Answers  


What is the maximum number of index per table?

0 Answers  


How do I list the available tables in a database I'm querying?

4 Answers  


Explain about system stored procedure?

0 Answers  


what information is maintained within the msdb database? : Sql server administration

0 Answers  


What are the advantages of partitioning?

0 Answers  


Categories