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

select names starts with a,b,c

Question Posted / prashant

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

Please Help Members By Posting Answers For Below Questions

What are the hotfixes and patches in sql server?

547

What is difference between foreign key and unique key?

554

What is resultset concur_updatable?

586

How to drop an existing user defined function in ms sql server?

570

Is sql server difficult to learn?

526

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

622

What are “phantom rows”?

1249

Where the sql logs gets stored?

545

What is a transactions?

606

What is temporal data type?

525

What is bcp? When does it use?

515

What is difference between clustered and non clustered index?

535

What are differences in between sql server 2012 and sql server 2016?

574

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

554

Can a table be moved to different filegroup?

574