Answers for "how to use subquery in sql"

SQL
1

why we use subquery in sql

We use subquery in order to get aggregate value in column without grouping data
Posted by: Guest on April-02-2021
1

what is subquery in sql

SUBQUERY IS NESTED QUERY INSIDE A SELECT, 
INSERT OR UPDATE METHODS. OR INSIDE ANOTHER SUBQUERY
Posted by: Guest on January-20-2021
0

subquery in sql

SELECT column_name
 FROM table_name1
WHERE VALUE IN 
(SELECT column_name
FROM table_name2 
WHERE condition)
Posted by: Guest on July-19-2021
0

subquery in sql

DELETE FROM dataflair_emp1
WHERE emp_id IN ( SELECT emp_id
                   FROM dataflair_emp2
                   WHERE age=25);  
select * from dataflair_emp1;
Posted by: Guest on July-19-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language