in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / nithya_raghu
select * from emp where empname like J%
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
Explain what are the database objects? : SQL Server Architecture
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Explain boyce and codd normal form(bcnf)?
Tell me what is the stuff and how does it differ from the replace function?
What is the maximum size of sql server database?
how you can list all the tables in a database?
What are transactions in sql?
Explain Normalization and DE normalization
What is difference between delete & truncate commands?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How you can get a list of all the table constraints in a database? : Sql server administration
Why we use functions in sql server?
What factors you will consider calculating the storage requirement for that view?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security