Using a column alias in a sql select where clause.

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Using a column alias in a sql select where clause.

Message

From

13/08/2002 08:59:44

Andrew Kershaw
Ipswich, United Kingdom

13/08/2002 08:36:11

Nilesh Soni
Mumbai, India

General information

Forum:

Oracle

Category:

Reports

Title:

Re: Using a column alias in a sql select where clause.

Miscellaneous

Thread ID:

00689055

Message ID:

00689075

Views:

Thanks for your help. We've found the answer now. We needed to put the decode statement into a HAVING clause:
SELECT order_id,
decode(status, 'Held', '1 - Held', 'Shipped', '2 - Shipped', '') as ordstatus
from order_header
having decode(status, 'Held', '1 - Held', 'Shipped', '2 - Shipped', '') = 'Shipped'

Map

View

Click here to load this message in the networking platform