in emptable i want to retrive the name of employee whose name in 'J'

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / reddy

8 Answers
9500 Views
I also Faced
E-Mail Answers

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