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 conditional split?
What is the stored procedure?
What is a cube? : sql server analysis services, ssas
Why is sql server log file full?
What are the recovery models in sql server 2000?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What do you mean by collation recursive stored procedure?
How to loop through result set objects using mssql_fetch_array()?
Explain what is “asynchronous” communication in sql server service broker?
What is a view in sql?
How to download and install the scaled-down database adventureworkslt?
How would you use user_constraints table in DB?
What happens if you add a new index to large table?
Explain about local stored procedure?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?