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

What are the new security features added in sql server 2012? : sql server security

1105


What is a database table?

1021


What is the difference between stored procedure and functions?

1195


What is use of attributehierarchyenabled? : sql server analysis services, ssas

1296


What is sql server used for?

1099


What are the advantages dts has over bcp?

1048


What is the difference between a function and a trigger?

1122


What is sharding?

116


Do you know the cursor types?

1202


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1106


What is ms sql server index?

1149


What are sp_configure commands and set commands?

1072


How will you make an attribute not process? : sql server analysis services, ssas

1157


Can select statements be used on views in ms sql server?

1105


What is the difference between local and global temporary tables?

1193