select names starts with a,b,c

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

815


If a table does not have a unique index, can a cursor be opened on it?

666


Why should we go for stored procedures? Why not direct queries?

750


What is an identity?

730


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

682


What are the properties of the relational tables?

635


Can group functions be used in the order by clause in ms sql server?

762


How many replicas are maintained for each sql azure db?

118


Explain about builtinadministrator?

775


Can you explain the disadvantages/limitation of the cursor?

677


Explain tablesample?

731


Explain the microsoft sql server delete command? : SQL Server Architecture

779


What is hot add cpu in sql server 2008?

702


What is create statement?

682


Write a query for primary key constraint with identity key word?

777