Home » SQL & PL/SQL » SQL & PL/SQL » Top / Bottom Query - Oracle 00907 Error
Top / Bottom Query - Oracle 00907 Error [message #224279] Tue, 13 March 2007 13:03 Go to next message
fes937
Messages: 7
Registered: March 2007
Junior Member
Hi,

I'm trying to create a Top / Bottom query from an example i already have but when i executed it, i got an error:
ORA-00907: missing right parenthesis

The coding i've got is:
SELECT customer_id, forename, surname, start_date_time, end_date_time, pos
FROM (
SELECT customer_id, forename, surname, start_date_time, end_date_time,
row_number() over (
partion by start_date_time
order by customer_id asc) pos
from customer, phone_call)
where pos = 1;

The error is on the partition line but i've closed all the open brackets,

Thanks in advance
Re: Top / Bottom Query - Oracle 00907 Error [message #224280 is a reply to message #224279] Tue, 13 March 2007 13:15 Go to previous message
fes937
Messages: 7
Registered: March 2007
Junior Member
Managed to fix it
Previous Topic: aggregating row data
Next Topic: updating table
Goto Forum:
  


Current Time: Thu Dec 08 02:38:25 CST 2016

Total time taken to generate the page: 0.07881 seconds