select * from table_name where Name like 'A%' union select * fr

select names starts with a,b,c

Question Posted / naren

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

Please Help Members By Posting Answers For Below Questions

What are the restrictions applicable while creating views? : SQL Server Architecture

1023

What is RMS migrations?

2134

Where actually sql azure database is hosted?

163

What is order of B+tree?

1107

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

945

What are the different types of normalization?

1167

what is a traditional network library for sql servers? : Sql server database administration

954

What are the differences between clustered and non-clustered index?

1033

what is isolation level at dead lock?

2151

How data can be copied from one table to another table?

950

What is the language structure to add a record to a table?

1025

What is normalization? Explain its different types?

1090

What is SQL Azure Data sync?

121

How to insert data with null values?

1030

What do you think of this implementation? Can this be implemented better?

945