What is a subselect? Is it different from a nested select?
A subselect is a select which works in conjunction with another select. A nested select is a kind of subselect where the inner select passes to the where criteria for the outer select.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How many ways we can we find the current date using MySQL? 06.11.08
SELECT CURDATE(); SELECT CURRENT_DATE(); SELECT CURTIME(); SELECT CURRENT_TIME();...Do JTS implementations support nested transactions? 27.10.08
A JTS transaction manager must support flat transactions; support of nested transactions is optional. If a client begins a transaction, and within that t...What is the difference between IN subselects and EXISTS subselect ? 03.04.08
If there is an index on the attributes tested an IN is more efficient since DB2 uses the index for the IN....Compare a subselect to a join ? 03.04.08
Any subselect can be rewritten as a join, but not vice versa. Joins are usually more efficient as join rows can be returned immediately, subselects require a...What is the cascade rule and how does it relate to deletions made with a subselect ? 01.04.08
The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made....What are different types of inner classes? 31.07.07
Nested top-level classes, Member classes, Local classes, Anonymous classes Nested top-level classes- If you declare a class within a class and specify the stat...What is a nested class? Why can it be useful? 04.05.07
A nested class is a class enclosed within the scope of another class. For example: // Example 1: Nested class // class OuterClass { class NestedClass {...What are types of Select statements? 09.04.07
SELECT SINGLE ... WHERE ... SELECT [DISTINCT] ... WHERE ... SELECT * ......How do you take care of performance issues in your ABAP programs? 06.04.07
Performance of ABAP programs can be improved by minimizing the amount of data to be transferred. The data set must be transferred through the network to the app...What are different types of inner classes? 30.08.06
Nested top-level classes, Member classes, Local classes, Anonymous classes Nested top-level classes- If you declare a class within a class and specify the st...