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

select names starts with a,b,c

Question Posted / naren

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Please explain go command in sql server?

989

What is difference statement and preparedstatement?

932

What is constraints and its types?

875

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

959

How do I find the sql server database version?

939

What is a dbms wizard?

965

Explain the difference between delete,drop and truncate in SQL Server?

1014

Can you please differentiate between a primary key and a unique key?

948

What is the datatype of rowid?

875

How many types of triggers in sql server?

967

How many ways to create table-valued functions?

932

What is the difference between deallocate cursor and close cursor?

1162

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2039

Explain tables in SQL Azure?

120

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

952