select names starts with a,b,c
Answer Posted / senthil
SELECT NAMES FROM TABLE_NAME
WHERE lower(NAME) LIKE 'a%'
or lower(NAME) LIKE 'b%'
or lower(NAME) LIKE 'c%';
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Is candidate a key?
What do you mean by an execution plan? How would you view it?
How to skip remaining statements in a loop block using continue statements?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
How to download and install the scaled-down database adventureworkslt?
What is DCL?
what is normalization? : Sql server database administration
Tell me what is log shipping?
What is statement level trigger?
What is the difference between mysql and sql server?
What is the recovery model?
Where the sql logs gets stored? : sql server database administration
What is the purpose of self join?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Explain the relational database management system (rdbms)?