SQL SUBSTRING: The Substring function in SQL is used to capture a portion of the stored data
Syntax:SUBSTR(str,pos,len): Starting with theth character in string and select the next characters.
Example:SELECT SUBSTR(company_name, 3) FROM Company WHERE company_name = �tata�;
Syntax:SUBSTR(str,pos,len): Starting with the
Example:SELECT SUBSTR(company_name, 3) FROM Company WHERE company_name = �tata�;
No comments:
Post a Comment