How to get values from filtered query using as a from table(Select clause withing another select clause for same fields) - Nested Query
SELECT TEMP_QUERY.Field1,
TEMP_QUERY.Field2
FROM (SELECT Field1, Field2 FROM TEST_TABLE
AND Field1 = 'TEST_VAL'
end_date IS NOT NULL
ORDER BY end_date) TEMP_QUERY
WHERE rownum = 1;
No comments:
Post a Comment