This script demonstrates various subquery techniques in SQL. It covers result types, subqueries in the FROM clause, in SELECT, with comparison operators, IN, ANY, correlated subqueries, and EXISTS.
Created a databse and also created 2 tables with name Country and persons ,then performed sql subqueries staements. Created a database named "product" ,within the database created a table with name " ...