Select MAX in subquery
Forum » Forum / Help » Select MAX in subquery
Started by: Rob (guest)
Date: 26 Jul 2011 05:37
Number of posts: 2
rss icon RSS: New posts
Summary:
I have created a query that uses a subquery to display result version numbers from result accumulators. I want to be able to pick the max row but when I try SELECT MAX in the expression I get an error. If I use a constant the query runs ok however I get extra data. This is the error with MAX used in the expression. SQL error. Stmt #: 5653 Error Position: 456 Return: 936 - ORA-00936: missing expression A SQL error occurred. Please consult your system log for details. Error in running query because of SQL Error, Code=936, Message=ORA-00936: missing expression (50,380)
New Post
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License