select names starts with a,b,c
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
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is self join in sql server joins?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Why are views required in the sql server or in any other database?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is trigger explain with program?
Explain alternate key, candidate key and composite key in sql server?
What is a view and what are its advantages?
In which format does an image save in SQL Server database ?
Can an automatic recovery be initiated by a user?
What is sql server profiler?
What action plan is preferred if sql server is not responding?
What is table valued function and scalar valued functions?
List out a number of the wants to setup a SQL Server failover cluster?