in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / 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 |
Post New Answer View All Answers
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Can we insert data if clustered index is disabled?
How to create a dynamic cursor with the dynamic option?
What's new in sql management studio for sql server? : sql server management studio
Explain what is sql server english query?
What are different types of raid levels?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What is an identity?
What is query parameter in ssrs?
How can sql server instances be hidden?
Can you force a query to use a specific index?
what is a transaction and what are acid properties? : Sql server database administration
What are the parts of a function?
Why we use functions in sql server?
Explain indexing and what are the advantages of it?