Informatics Practices
While using SQL pattern matching, what is the difference between '_' (underscore) and '%' wildcard symbols ?
SQL Queries
2 Likes
Answer
In SQL pattern matching, the underscore ('_') character matches any character, while the percent ('%') wildcard character matches any substring.
Answered By
1 Like
Related Questions
Is NULL value the same as 0 (zero) ? Write the reason for your answer.
Write the UPDATE command to increase the commission (Column name : COMM) by 500 of all the Salesmen who have achieved Sales (Column name : SALES) more than 200000. The table's name is COMPANY.
Write one similarity and one difference between CHAR and VARCHAR data types.
Write SQL statement to display
Today, the date is <current date>