Title: RE: [Q] SQLPLUS help on distinct
order by (rpad(employee_id,6,' '))
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts
Select distinct employee
From (select rpad(employee_id,6,' ')) ||';'||ssn as employee
from EMP
order by employee_id)
Jack
-Original Message-
Sent: Friday, August 29, 2003 4:45 PM
To: Multiple recipients of list ORACLE-L
I have problem to use distinct with Function
Mike,
Add a GROUP BY command:
select distinct (rpad(employee_id,6,' ')) ||';'|| ssn
from EMP
group by (rpad(employee_id,6,' ')) ||';'|| ssn
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, August 29, 2003 10:45 AM
To: Multiple recipients
Title: RE: [Q] SQLPLUS help on distinct
Mike,
Try one of these:
select distinct (rpad(employee_id,6,' ')) ||';'|| ssn
from EMP
order by (rpad(employee_id,6,' ')) ||';'|| ssn;
or
select distinct employee_id, (rpad(employee_id,6,' ')) ||';'|| ssn
from EMP
order by employee_id
2003 06:44:40
I have problem to use distinct with Function on
select statement. Can anyone give me a hint?
Thanks.
SQL select distinct (rpad(employee_id,6,' '))
||';'||
ssn from EMP
2 order by employee_id;
select distinct (rpad(employee_id,6,' ')) ||';'||
ssn
from EMP
GROUP BY does not necessarily guarantee a sort.
eg. you still need an ORDER BY
On Fri, 2003-08-29 at 07:59, Mercadante, Thomas F wrote:
Mike,
Add a GROUP BY command:
select distinct (rpad(employee_id,6,' ')) ||';'|| ssn
from EMP
group by (rpad(employee_id,6,' ')) ||';'|| ssn
Hope