468,103 Members | 1,337 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,103 developers. It's quick & easy.

DISTINCT ON function in toad

I have the following code:

SELECT DISTINCT ON (REQUEST_ID) BATCH_ID, REQUEST_ID FROM VOLUNTEER_REQUEST

I am recieving the error 'ORA-00936: missing expression' what am I doing wrong?

Basically I have multiple rows and every column data is the same except for two columns and I can't exclude these columns. I don't want the multiple rows to be return, I just want one to return and the columns are linked with the batch_id column. Is this even possible?

Thank you.
Nov 9 '06 #1
1 5059
I think you are giving wrong syntx inseated of previous query just run the
below query
SELECT DISTINCT (REQUEST_ID) BATCH_ID, REQUEST_ID FROM VOLUNTEER_REQUEST

Thanks
Nov 10 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Colin Steadman | last post: by
1 post views Thread by Joel Racicot | last post: by
2 posts views Thread by Salvador Valencia | last post: by
2 posts views Thread by luku | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.