select names starts with a,b,c

Answer Posted / lakshmi narayanan r

SELECT * FROM abc a WHERE a.ename LIKE '[a-c]%'

Is This Answer Correct ?    19 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe in brief databases and sql server databases architecture.

683


What are the types of processing and explain each? : sql server analysis services, ssas

904


in the physical file layout, where should the transaction log be stored in relation to the data file?

723


How to execute multiple stored procedures at one time in sql server?

688


What is the beast way to write CTE in SQL Server ?

762






What are the dmvs?

769


Can I use sql azure as a backup with log shipping or database mirroring?

148


What is log ldf?

725


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

836


What is database mirroring?

754


What are different types of raid configurations? : SQL Server Architecture

731


How many levels of sp nesting is possible?

795


How to create a login account in ms sql server to access the database engine using "create login" statements?

735


Explain raiserror in sql server?

754


How to assign new column names in a view?

666