Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajendra prasad reddy penumall
'Like' operator is a pattren matching operator.
Eg;
select name from class where name like 'a%'
selecting names starting with letter 'a' and any length
select name from class where name like '_a%'
selecting names starting with second with letter 'a' and
any length.
select name from class where name like '[abc]%'
selecting names starting with first letter 'a'or 'b'
or 'c' and any length.
select name from class where name like '[^abc]%'
selecting names except starting with first letter with
letter 'a'or 'b' or 'c' and any length.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are distinctive joins find as a part of sql?
How you can minimize the deadlock situation?
Differentiate between SQL and ORACLE joins and write their syntax.
What are difference between Cluster index and Non-Cluster index?
What is intellisense?
What are the triggers in sql?
Tell me what is difference between clustered and non clustered index?
What is the purpose of grouping data in a report?
Explain different types of Normalization.
What does asynchronous call backs means?
How to insert data into an existing table?
What is candidate key with example?
Where the sql logs gets stored?
Define candidate key, alternate key, and composite key.
Why use “pivot” in sql server?
