Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

Answer Posted / muthu kumar

select * from emp where empname like '%j%'

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is checkpoint process in the sql server?

1074


What are the steps you will take to improve the performance of a poor performing query?

1022


How to choose all records from the table?

1106


What are drilldown reports?

160


Tell me extended events in sql server 2008?

1055


What is the synonym of join?

1018


List the different types of joins?

1061


what is memory-optimized nonclustered indexes

1064


can an automatic recovery be initiated by a user? : Sql server administration

996


how to control the amount of free space in your index pages? : Sql server database administration

1087


What is temporal data type?

967


Can you always create a cache of a report?

178


What is standby servers? Explain types of standby servers.

1058


What stored by the model? : sql server database administration

1004


Write a query for primary key constraint with identity key word?

1084