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
Answer / muthu kumar
select * from emp where empname like '%j%'
Is This Answer Correct ? | 12 Yes | 1 No |
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 |
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 |
Answer / ashok
select * from employee where name like=%'j'%
Thanx
Ashok
Is This Answer Correct ? | 1 Yes | 7 No |
Answer / ashok
select * from employee where name like=%'j'%
Thanx
Ashok
Is This Answer Correct ? | 0 Yes | 7 No |
What is rolap and its advantage? : sql server analysis services, ssas
How to define output parameters in stored procedures?
How will u test the stroded procedures and functions? difference between SP and Triggers
define and explain the differences between clustered and non-clustered indexes.
How to see the event list of an existing trigger using sys.trigger_events?
What is the difference between indexing and hashing?
What is a print index?
What is a unique index?
Which joins are sql server default?
How to download and install microsoft sql server management studio express?
here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d
How to convert a table data in XML format in sql server?