A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Inner Query Execution
Joined: Jul 18, 2012
Jun 17, 2014 21:08:23
select :name from (select empName from Employee);
Suppose the Inner query (select empName from Employee) gives one name 'XYZ'.
And as we know the Inner query and sub query execute first then why we not write directly
select :name from XYZ inplace of writing select :name from (select empName from Employee);
author & internet detective
Joined: May 26, 2003
Jun 20, 2014 21:09:08
In this case you would. Inner queries should only be used when they are performing a task that can't be accomplished with a regular simple query.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
subject: Inner Query Execution
Fetching data using jdbc....query doubt
How do lower/upper work in SQL?
how to write select query when where condition contains ampersand symbol(&)?
How to get a XPath and X-query with the XML document
Nested Queries with comparison operators
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014