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

Can you tell me about the concept of ER diagrams?

1122


Can foreign key be duplicate?

1120


Explain what are the authentication modes in sql server?

1073


How to provide values to user defined function parameters?

1064


How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1078


What is data source in connection string?

958


What is the impact on other user sessions when creating indexes?

966


What languages bi uses to achieve the goal?

1052


Explain transaction server auto commit?

1092


How to create an index on an existing table in ms sql server?

1028


What is a not null constraint?

1089


Which are the new data types introduced in sql server 2008?

931


Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1224


How to create a user name in a database?

1103


What are the differences between user defined functions and stored procedures?

1137