Structured query language

Data Science, AI and ML
#1

what is the difference between substr and substring function?

#2

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

#4

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?

#5

can you please solve this question?
here is the link-Structured query language select and group by.

#6

SQL - Structured Query Language (SQL) is a standard computer language for relational database management and data manipulation. This language is mainly used to communicate with databases. We write SQL statements to retrieve data which are called as queries. Used to create databases, create tables, insert data, update data or delete data. It can provide access by using Grant or revoke the access.

It has 5 sub languages:-

  1. Data Definition Language
  2. Data Manipulation Language
  3. Data Retrieval Language
  4. Data Control Language
  5. Transaction Control Language