Question
in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Question Submitted By :: Reddy
I also faced this Question!!
Rank
Answer Posted By
Re: in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer 1 select * from emp where empname like J%
Nithya_raghu
Re: in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer 2 select * from emp where empname like '%j%'
Muthu Kumar
Re: in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer 3 select * from employee where name like=%'j'%
Thanx
Ashok
Ashok
Re: in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer 4 select * from employee where name like=%'j'%
Thanx
Ashok
Ashok
Re: in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer 5 select * from Emp where name like '%j%'
Ashok
Re: in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer 6 select * from emp where name like '%J%'
Kalpana
Re: in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer 7 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%'
Deepa
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
