Interested to Buy Any Domain ? << Click Here >> for more details...
what is different between inline query,subquery& corelated
query?
- 8 Answers
- 107008 Views
- Quest, I also Faced
- E-Mail Answers
Answer Posted / ramesh reddy veerabhadra
Basically Sub Query is Query within Query. There are different type of SubQuery.
1. Scalar Sub Query
Query that is totally independent from the main query.
select empno, (select count(*) from emp) total_emp
from emp
here the subquery is totally independent of the main query.
2. Corelated Sub Query
The sub query reffers to the main query.
select empno, (select deptname from dept d where e.deptno = d.deptno) deptname
from emp e
3. Inline view
A sub query that is used as a table or view in a SQL
select *
from (select empno, deptname
from emp e, dept d
where e.deptno = d.deptno)
where sal > 100
| Is This Answer Correct ? | 42 Yes | 12 No |
Post New Answer View All Answers
What is auto invoicing? Explain : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
3. Steps in UAT?
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
8. Supporting AP, AR and GL?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
HOW TO SPOT AHIERARCHY?
key flexfield structure
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
Could you please let me know the interfaces in OM / FA??
Explain the payment term in ar. : oracle accounts receivable
what are the tools used for oracle 10g in real time.
A scenario for amount correction & how to use amount correction functionality in AP invoices
