Is there another operator - other than rownum - in Oracle to display the top result in a query

Asked Feb 15 '19 at 10:04

Active Feb 16 '19 at 23:23

Viewed 75 times

I'm new to coding,please keep that in mind,currently I'm learning in Italian, therefore are some mistake in spelling.

I have a small Database regarding a dvd-rental, I write this code and the result is nicely showing, but I need only the top row.

select count(dvd_neloggio.id_dvd),
       film.titolo,
       grouping(dvd_neloggio.id_dvd) top
from dvd_neloggio
  inner join dvd on dvd_neloggio.id_dvd=dvd.id_dvd
  inner join film on dvd.id_film=film.id_film
group by dvd_neloggio.id_dvd,film.titolo
order by  dvd_neloggio.id_dvd;

edited Feb 16 '19 at 23:23

William Robertson

12,552
3
33
36

asked Feb 15 '19 at 10:04

roland.adrian

What DB do you use? – Robert Kock Feb 15 '19 at 10:07
3

`fetch first x rows only`? – a_horse_with_no_name Feb 15 '19 at 10:08
ty you very much, i will try – roland.adrian Feb 15 '19 at 10:09
@RobertKock `oracle` is tagged – Muhammad Waheed Feb 15 '19 at 10:41
2

Possible duplicate of [How do I limit the number of rows returned by an Oracle query after ordering?](https://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering) – JohnHC Feb 15 '19 at 11:01
Please explain why you are using the `GROUPING()` function. It doesn't really make sense in this context. – Gordon Linoff Feb 15 '19 at 11:47
Thank you all very much, it worked with rownum. I am using Sqldeveloper – roland.adrian Feb 15 '19 at 11:49
I'm only three months into the coding, so i had looking for other operators. I used grouping() just to see what happens.I finded grouping() more friendlier than group_id – roland.adrian Feb 15 '19 at 11:52
I will try to explain as good as I can, I dont like rownum beucause you must insert after the query is done – roland.adrian Feb 15 '19 at 12:04
`rownum` isn't an operator. – William Robertson Feb 16 '19 at 23:24
I found the right answer. I made a subquery with the Having statement, using the Max function! Thanks everybody for the assist! – roland.adrian Feb 20 '19 at 10:44

Is there another operator - other than rownum - in Oracle to display the top result in a query

0 Answers0