Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP with SQL
<akchittanuri_at_gmail.com> a écrit dans le message de news: 1131706261.589261.200600_at_z14g2000cwz.googlegroups.com...
| Michael,
| 1) execution of the query
|
| select a.ctry_name, b.city_name,
| row_number() over (partition by a.ctry_name, b.city_name)
| rn
| from country a, city b where a.ctry_id = b.ctry_id
|
| gave the error...
|
| ORA-30485: missing ORDER BY expression in the window specification
|
My apologies, i forgot order by clause but this could be corrected with a look at the SQL Reference: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions105a.htm#86312
Regards
Michel Cadot
Received on Fri Nov 11 2005 - 05:05:58 CST