What is the Subquery?
Answers were Sorted based on User's Feedback
Answer / suresh kumar somayajula
SELECT Statement which is embedded in another class of
SELECT statement is nothing but "Sub-Query".
In this ..Inner query will execute first.based on that
result outer query will execute.
Thank you,
Suresh
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / anil_abbireddy
Runs first,executed once,returns values to be used by the
MAIN Query
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ramesh
A sub query is a query and it is deepened main query on the another query is called as a sub-query.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rashmi
Query inside a query is called sub query. Always to execute successfully the outer query depends on the output of inner query.
it is if 4 types.
>Scalar sub query
>Corelated sub query
>Nested sub query
>Inline view
Is This Answer Correct ? | 0 Yes | 0 No |
What is data control language?
What is the difference between row level and statement level trigger?
I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
What is a native sql query?
How do you drop a trigger?
What port does sql server use?
What is oracle and pl sql?
Which sql most popular?
How do I enable sql encryption?
What are the syntax and use of the coalesce function?
Explain the difference between sql and mysql.