Monday, June 17, 2013

Oracle - PL/SQL Query

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