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

select names starts with a,b,c

Question Posted / gopinath

8 Answers
14187 Views
Scope International, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1632

Explain how you can deploy an SSRS report?

150

Explain features and concepts of analysis services?

979

Explain Geography datatype in SQL Server

1132

How can a database be repaired?

990

What are the different types of normalization?

1167

What is report server project?

147

What are the types of indexes?

1084

Explain boyce and codd normal form(bcnf)?

959

What is hot add cpu in sql server 2008?

930

Name few of the dcl commands in sql?

1007

What is 1nf normalization form?

1036

What is similarity and difference between truncate and delete in sql?

1102

How to delete database objects with "drop" statements in ms sql server?

1090

1 01 101 01010

2055