ORA-01791: not a SELECTed expression
I need to fetch details from DB. Any thing wrong in my code?SELECT DISTINCT FNAME, LNAME, MEMBERORG, DAYCOUNT, TIMESTAMP, COUNT(FNAME) AS total,(SELECT COUNT(*) FROM REPORT_VIEW_PAGE) AS tot FROM REPORT_VIEW_PAGE WHERE ID = '68' AND TYPE = 'node' GROUP BY FNAME, LNAME, MEMBERORG,...