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 is the maximum size per database for sql server express?

559

What is the most common trace flags used with sql server?

524

Tell me what do we need queues in sql service broker?

523

Can we linked SharePoint to a SQL database?

596

your distribution database is full what will u do

1681

What is a fill factor?

627

explain different types of backups avaialabe in sql server? : Sql server database administration

596

What is the purpose of indexing?

599

What is normalization of database? What are its benefits?

518

What is a derived table?

515

Write the SQL query to drop, truncate and delete table.

554

Describe different Processing Modes offered by SSRS?

164

What is b tree index?

518

How to add more data to the testing table in ms sql server?

556

How to get the definition of a stored procedure back?

530