in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / ashok
select * from employee where name like=%'j'%
Thanx
Ashok
Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What is 2nf normalization form?
What are page splits? : SQL Server Architecture
How do I debug a stored procedure in sql server?
How to generate random numbers with the rand() function in ms sql server?
How can you fetch alternate records from a table?
What are the requirements to use odbc connections in php scripts?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What are the rendering extensions of ssrs?
Why do we use stored procedures in sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is PROJECTION Operation?
How do use Having,Group by,Group function in SQL?
What are different types of subquery?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is an execution plan?