Welcome!
Log In
Create A New Profile
Home
>
2010
>
INF307H
> Topic
Advanced
Assignment 2 Q11
Posted by
BigSteve
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
Forums
Messages
New
BigSteve
Assignment 2 Q11
July 29, 2010 05:00PM
Registered: 15 years ago
Posts: 14
Rating: 0
Has anyone done this question yet ?
How did you restrict the selection to 3 rows ?
Reply
Quote
rezrovs
Re: Assignment 2 Q11
July 29, 2010 06:04PM
Registered: 17 years ago
Posts: 308
Rating: 0
Have a look at using ROWNUM in the where clause. I don't have my manuals with me so I can't give the page reference - will try to do it later if I can.
Reply
Quote
trinity
Re: Assignment 2 Q11
July 29, 2010 07:11PM
Registered: 15 years ago
Posts: 68
Rating: 0
Yes, the ROWNUM does the trick.
Reply
Quote
BigSteve
Re: Assignment 2 Q11
July 30, 2010 07:26AM
Registered: 15 years ago
Posts: 14
Rating: 0
Cool , thanks
I did some research and found out about ROWNUM , however was not sure if we could use it a i did not see it the manuals , will check again.
Reply
Quote
trinity
Re: Assignment 2 Q11
July 30, 2010 09:10AM
Registered: 15 years ago
Posts: 68
Rating: 0
In manual 1, they talk about ROWNUM. But it;s not very clear how to use it.
Reply
Quote
Newer Topic
Older Topic
Print View
RSS
Sorry, only registered users may post in this forum.
Click here to login