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 / 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

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

936


What does the on delete cascade option do?

996


What is difference between count (*) and count 1?

908


Is a primary key unique?

975


How to find tables without indexes?

1071


Define left outer join in sql server joins?

943


What are sql server functions?

960


Explain can SSRS reports Cache results?

158


What are the instances when triggers are appropriate?

965


What is transaction server distributed transaction?

1021


what's the information that can be stored inside a bit column? : Sql server database administration

1006


How data can be copied from one table to another table?

929


What are the recovery models for a database?

1094


What is the difference between dbcc indexdefrag and dbcc reindex?

966


Does sql server use java?

1049