Interview Questions and Answers
Difference between Subquery and Derived table
Difference between subquery and derived table:
Subquery | Derived |
Subqueries must be enclosed within parentheses. | Derived table must be enclosed within parentheses and table name must be provided. |
Subquery can have only one column. | Derived table can have one or more column. |
Subquery mainly use in where clause. | Derived table used in from clause. |
Post a Comment
0 Comments