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

How to replace null values in expressions using isnull()?

1078


How adventureworkslt tables are related?

911


What are the types of database schema? : sql server analysis services, ssas

1107


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2755


What are the differences between having and where clause.

954


Explain different types of Normalization.

1796


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1083


Why do we use trigger?

948


how to define testing of network layers? : Sql server database administration

953


Different types of keys in SQL?

1080


How do you rebuild an identity column?

931


Define tempdb database?

973


How do you create a clustered index?

1034


What are the restrictions that views have to follow? : SQL Server Architecture

973


Which rendering formats are affected by the pagesize properties?

144