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
How to create an index on a view?
What is t-sql script to take database offline – take database online.
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Do you know what are pages and extents? : SQL Server Architecture
Explain the different types of backups available in sql server? : sql server database administration
Can an entity have two primary keys?
What is Replication?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What to check if a User database is locked?
How to remove duplicate rows from table?
Why I am getting this error when renaming a database in ms sql server?
What is a periodical index?
what is a self join? : Sql server database administration
How to find related tables in sql server?
What is simple indexing method?