SAP (Documents/Screen shots/Complete Solution): RE:[oracle-db-l] Oracle Order by Clause

Reply from SteveFLHSMV on May 27 at 3:06 PM

You can do something like that with subqueries using the column aliases from an inline view or factored subquery. You can also use positional references in the order by clause but not the where or group by clauses.

with fs as (
select col1 c1, col2 c2, col3 c2 from mytable)
select * from fs
where c1 > 12 and c2 like '*PDF'
group by c1
order by 1, 3

---------------Original Message---------------
From: Shivas san
Sent: Sunday, May 27, 2012 10:03 AM
Subject: Oracle Order by Clause

Hi,

Is there any way to use alias columns in order by clause and where clause
condition.

Thank you
Shivasson

Reply to this email to post your response.

__.____._

Manage Settings | Unsubscribe | Create FAQ | Send Feedback