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


Please Help Members By Posting Answers For Below Questions

How do you delete duplicate records in sql server?

723


Explain Geometry datatype in sql server 2008 with example

751


What is the definition for sql server 2000?

788


What does man by sql wildcard characters in sql server?

708


can a table be moved to different filegroup? : Sql server administration

712






but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

719


What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

848


How to define and use table alias names in ms sql server?

743


What is the difference between push and pull subscription? : sql server replication

852


Is sql server a database?

693


What is the most common trace flags used with sql server?

682


Name three of the features managed by the surface area configuration tool? : sql server security

713


Why use update_statistics command in sql server?

743


What is indexed view? How to create it?

757


can you implement data mining in SSRS?

125