select names starts with a,b,c
- 8 Answers
- 11833 Views
- Scope International, I also Faced
- E-Mail Answers
Answer Posted / naren
Lakshmi Narayanan u r correct.
But we can use the table only.
SELECT * FROM abc WHERE ename LIKE '[a-c]%'
I think its better...
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is GUID in sql server?
Explain linked server in sql?
How to use copy and concatenate commands in SQL?
What is an sql server agent?
How can we remove orphan records from a table?
What action plan is preferred if sql server is not responding?
What is the difference between DATETIME2 and DATETIME?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What are the differences between sql server and mysql.
Do you know what are various aggregate functions that are available?
what is isolation level at dead lock?
Tell me something about security and sql azure?
Define cross join in sql server joins?
How to generate random numbers with the rand() function in ms sql server?
How do we know if any query is retrieving a large amount of data or very little data?
