A subquery is a query that is nested inside a Select, Insert, Update or Delete statement. It can also be inside another subquery. A subquery can return a set of rows or a single row to its parent subquery.
example
Update RECORDS
set Name =’Alex’ where Name in(Select Name from RECORDS where Id = 01);
Subquery is query within a query. This is used to ensure that the WHERE condition is further getting values from another query. The inner query executes first before its parent query so that the results of inner query can be passed to the outer query.
Select employee_name, salary from employee where designation = (select designation from positionmaster where positioncategory like ‘%MANAGER%’)
If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com
March 14, 2015 at 8:34 pm
A subquery is a query that is nested inside a Select, Insert, Update or Delete statement. It can also be inside another subquery. A subquery can return a set of rows or a single row to its parent subquery.
example
Update RECORDS
set Name =’Alex’ where Name in(Select Name from RECORDS where Id = 01);
March 22, 2015 at 2:22 pm
Subquery is query within a query. This is used to ensure that the WHERE condition is further getting values from another query. The inner query executes first before its parent query so that the results of inner query can be passed to the outer query.
Select employee_name, salary from employee where designation = (select designation from positionmaster where positioncategory like ‘%MANAGER%’)
March 23, 2015 at 11:45 pm
a sub query is query inside a query like nasir said above the where condition it executes the select then the where
March 24, 2015 at 7:32 pm
It is a query inside another query. An example would be select * from Players
WHERE ID IN (Select ID FROM Players where goals > 15);
– Tomiwa
March 28, 2015 at 6:56 pm
Sub query is the nested query.
Navigation
Loading Questions
If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com
Edit Profile