exam
Posted by peanut001
| Announcements | Last Post | |
|---|---|---|
 |
SoC Curricula | 09/30/2017 01:08PM |
|
Demarcation or scoping of examinations and assessment | 02/13/2017 07:59AM |
|
School of Computing Short Learning Programmes | 11/24/2014 08:37AM |
|
Unisa contact information | 07/28/2011 01:28PM |
|
November 18, 2009 08:42PM |
|
November 19, 2009 12:09AM |
|
November 19, 2009 12:11AM |
|
Re: exam November 19, 2009 01:38AM |
Geeza,
1.3 and 1.5 are perfectly valid Oracle scripts and are not necessarily Access based, infact Access doesnt like doing subqueries and rather does JOINs like 1.2.
What the sub query is doing is building a list of all the Department names which are on floor 1. The "IN" from the main query then makes the comparison.
The results would be similar to hardcoding the dept.names like
The question is not very specific as you could also use the following subquery script
So as you can see those are just 2 ways of getting the results using subqeries, and there are probably many more costly ways
The eaisiet way to work with SQL is to try and structure it similar to the above (or to your preferrence). I find it just helps to read it better, plus subqueries are easier to understand if read from the inside out.
Cheers
Darren
1.3 and 1.5 are perfectly valid Oracle scripts and are not necessarily Access based, infact Access doesnt like doing subqueries and rather does JOINs like 1.2.
What the sub query is doing is building a list of all the Department names which are on floor 1. The "IN" from the main query then makes the comparison.
The results would be similar to hardcoding the dept.names like
Language: SQLSELECT DISTINCT Item_Name FROM SALE WHERE Dept_Name IN (';Books';, ';Navigation';)
The question is not very specific as you could also use the following subquery script
Language: SQLSELECT DISTINCT Item_Name FROM SALE, (SELECT DISTINCT Dept_Name FROM DEPT WHERE Dept_Floor = ';1';) XYZ WHERE SALES.Dept_Name = XYZ.Dept_Name
So as you can see those are just 2 ways of getting the results using subqeries, and there are probably many more costly ways
The eaisiet way to work with SQL is to try and structure it similar to the above (or to your preferrence). I find it just helps to read it better, plus subqueries are easier to understand if read from the inside out.
Cheers
Darren
|
November 19, 2009 11:27PM |
|
November 19, 2009 11:31PM |
NO ONE TOLD ME THAT THE ORACLE CD DOESNT WORK ON WINDOWS VISTA!!!
|
November 20, 2009 10:15AM |
ExtraLarge Wrote:
-------------------------------------------------------
> NO ONE TOLD ME THAT THE ORACLE CD DOESNT WORK ON
> WINDOWS VISTA!!!
Doesn't work on 7 either as I found out yesterday
-------------------------------------------------------
> NO ONE TOLD ME THAT THE ORACLE CD DOESNT WORK ON
> WINDOWS VISTA!!!
Doesn't work on 7 either as I found out yesterday
|
November 20, 2009 10:48AM |
|
November 20, 2009 03:54PM |
|
November 20, 2009 04:18PM |
|
November 20, 2009 04:34PM |
|
November 20, 2009 05:49PM |
Sorry, only registered users may post in this forum.