Re: [Q] need help on SQLplus select "distinct" !!

but just ignoring message is NOT what this list is all about.

Joe

mike mon wrote:

> sorry about that, but if you don't want answer, you can easy to
> ignore. You don't need insult other people. You may good, but
> everyone sometime still need start from fresh.
>
>
> */"Odland, Brad" <Brad.Odland_at_qtiworld.com>/* wrote:
>
> Are you doing homework...?
>
> Shame on you
>
> -----Original Message-----
> Sent: Tuesday, September 23, 2003 10:00 AM
> To: Multiple recipients of list ORACLE-L
>
>
> I plan to select distinct data from table. anyone has
> suggestion?
>
> Thanks.
>
> select distinct employee
> from (select employee_id, lname, fname, mi, hiredate
> , as employee from emp)
> SQL>
> SQL> /
> from (select employee_id, lname, fname, mi, hiredate ,
> as employee from emp)
>
> *
> ERROR at line 2:
> ORA-00936: missing expression
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: mike mon
> INET: mccdba_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Odland, Brad
> INET: Brad.Odland_at_qtiworld.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! SiteBuilder
> <http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com> -
> Free, easy-to-use web site design software

-- 
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the "CACHE"


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).