what is the difference between substr and substring function?
SUBSTR is the function from Oracle
SUBSTRING is the function from MySql
The SUBSTRING() function extracts some characters from a string.
for more details pls visit: https://www.w3schools.com/sql/func_sqlserver_substring.asp
sir you have said that substr function belongs to oracle but i have seen it in mysql documentation.
here is the link you can go for it-https://dev.mysql.com/doc/refman/8.0/en/string-functions.html.
and tell me which is right?
can you please solve this question?
here is the link-Structured query language select and group by.