Answers for "substr in sql query"

SQL
6

sql substring

-- substr(string, start, [, length ])
SELECT substr('Hello World', 1, 3) ;      -- Hel
SELECT substr('Hello World', 4, 5) ;      -- lo Wo
SELECT substr('Hello World', 4);          -- lo World
SELECT substr('Hello World', -3);         -- rld
Posted by: Guest on May-02-2021
0

substring sql

SELECT SUBSTR(first_name, 0 , 3)
From employees;
Posted by: Guest on January-28-2021
1

subquery in sql

UPDATE dataflair_emp1 
SET salary=35000
WHERE emp_id  = ( SELECT emp_id
                    FROM dataflair_emp1
                    WHERE post='Sr.Manager');     
select * from dataflair_emp1;
Posted by: Guest on July-19-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language