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
Can you tell me about the concept of ER diagrams?
Can foreign key be duplicate?
Explain what are the authentication modes in sql server?
How to provide values to user defined function parameters?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is data source in connection string?
What is the impact on other user sessions when creating indexes?
What languages bi uses to achieve the goal?
Explain transaction server auto commit?
How to create an index on an existing table in ms sql server?
What is a not null constraint?
Which are the new data types introduced in sql server 2008?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How to create a user name in a database?
What are the differences between user defined functions and stored procedures?