what operator performs pattern matching?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / deepak
Pattern matching is used to get the information without
mentioning the full name and by just using the LIKE operator
and just mention the starting letter.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can two tables have the same primary key?
What happens if you insert a duplicate key for the primary key column in ms sql server?
what is cluster and nin-cluster index?
How many types of cursors are there in SQL Server?
5 Answers 247Customer, CarrizalSoft Technologies,
What is similarity and difference between truncate and delete in sql?
Describe in brief databases and sql server databases architecture.
What stored by the master? : sql server database administration
How to change server name in sql server?
What is transactional replication?
How check triggers in sql server?
What are the different types of joins and what does each do?
Can you tell me about the concept of ER diagrams?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)