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

19. Display all clients whose name begins with the letter J
or contains the letter M anywhere or contains E as the third
letter.

Answer Posted / suresh babu

select client_name from client where client_name like 'j%'
or client_name like '%M%' or client_name like '___E%';

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the attributes of the cursor?

1004


how may join possible between (requisition with purchase order)

2250


How to use null as conditions in oracle?

1084


How to add a new column to an existing table in oracle?

1139


What is a user account in oracle?

1121


What is difference between cartesian join and cross join?

1088


How to set a transaction to be read only in oracle?

1093


What is recycle bin in Oracle?

1150


How to convert times to characters in oracle?

1027


Explain constraining triggers.

1095


Give the different types of rollback segments.

1031


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2065


Is there a combination of "like" and "in" in sql?

1065


How do I find the database name in oracle?

1038


How to do clean up if create database failed?

1028