Informatics Practices
Which of the following functions returns the substring from a given string ?
- MID
- INSTR
- SUBSTR
- CHAR
SQL Queries
3 Likes
Answer
MID, SUBSTR
Reason — The SUBSTRING()/SUBSTR() and MID() functions can be used to extract substrings from a given string.
Answered By
3 Likes
Related Questions
Which of the following is not a numeric function ?
- MOD
- SIGN
- MID
- POW
Which of the following is not a date function ?
- Month
- Year
- NOW
- POW
Which of the following functions returns the position of a substring in a given string ?
- MID
- INSTR
- SUBSTR
- CHAR
Which one of the following is not an aggregate function ?
- ROUND()
- SUM()
- COUNT()
- AVG()