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


select names starts with a,b,c

Answers were Sorted based on User's Feedback



select names starts with a,b,c..

Answer / lakshmi narayanan r

SELECT * FROM abc a WHERE a.ename LIKE '[a-c]%'

Is This Answer Correct ?    19 Yes 1 No

select names starts with a,b,c..

Answer / prashant

SELECT NAMES FROM TABLE_NAME
WHERE NAME LIKE 'a%'
or NAME LIKE 'b%'
or NAME LIKE 'c%'

Is This Answer Correct ?    16 Yes 6 No

select names starts with a,b,c..

Answer / naren

Lakshmi Narayanan u r correct.
But we can use the table only.

SELECT * FROM abc WHERE ename LIKE '[a-c]%'

I think its better...

Is This Answer Correct ?    10 Yes 2 No

select names starts with a,b,c..

Answer / senthil

SELECT NAMES FROM TABLE_NAME
WHERE lower(NAME) LIKE 'a%'
or lower(NAME) LIKE 'b%'
or lower(NAME) LIKE 'c%';

Is This Answer Correct ?    8 Yes 3 No

select names starts with a,b,c..

Answer / rajkumar v

SELECT * FROM TABLE_NAME WHERE Colum_Name LIKE '[a-c]%'
OR
SELECT * FROM TABLE_NAME WHERE Colum_Name LIKE '[a,b,c]%'

Is This Answer Correct ?    1 Yes 0 No

select names starts with a,b,c..

Answer / gopinath

SELECT NAMES FROM TABLE_NAME
WHERE NAME LIKE 'a%'
or NAME LIKE 'b%'
or NAME LIKE 'c%'

Is This Answer Correct ?    2 Yes 2 No

select names starts with a,b,c..

Answer / roopesh kumar

Select * From emp Where substr(ename,1,1) In
('a', 'b', 'c', 'S');

Is This Answer Correct ?    1 Yes 4 No

select names starts with a,b,c..

Answer / naren

select * from table_name where Name like 'A%'
union
select * from table_name where Name like 'B%'
union
select * from table_name where Name like 'C%'

Is This Answer Correct ?    6 Yes 10 No

Post New Answer

More SQL Server Interview Questions

How do I get to sql server configuration manager?

0 Answers  


How do I find my localdb version?

0 Answers  


What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,


Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  


what is the query and condition to delete datas in sql server.

2 Answers  


What is a join and their types?

2 Answers   Challenger Financial,


What is entity data services?

0 Answers  


what are the problems in logshipping?

3 Answers  


Explain what is log shipping?

0 Answers  


What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,


What is indexing explain it with an example?

0 Answers  


wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,


Categories