The Advance word in the Advance SQL is added because the Advance SQL have many additional features. And many of the features are discussed below.
SELECT TOP [TOP argument] "column_name"
Where [TOP argument] means one of them:
SELECT TOP 2 `prod_id`, `prod_sales`, `date` FROM `product_information` ORDER BY `prod_sales` DESC ;
SELECT "column_name1" FROM "table_name1" WHERE "column_name2" [Comparison Operator] (SELECT "column_name3" FROM "table_name2" WHERE "condition");
The Comparison Operator which are used are =,>, <,>=, <=.we can also use text operator such as “LIKE”.Example: Two tables product_detail and product_information having a common field i.e. prod_id and two different fields
SELECT "column_name1" FROM "table_name1" WHERE EXISTS(SELECT * FROM "table_name2" WHERE "condition");Example: Two tables customer and score having a common field i.e. cust_id
To use SQL-CASE we have two way:
SELECT CASE ("column_name") WHEN "value1" THEN "result1" WHEN "value2" THEN "result2" ... [ELSE "resultN"] END FROM "table_name";Example: There is one table (product_information) with three fields i.e. prod_id,prod_sales,date in the prod_sales we have applied cases condition
Assignment Writing Help
Engineering Assignment Services
Do My Assignment Help
Write My Essay Services