[Q] need help on SQLplus select distinct !!

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)

RE: [Q] need help on SQLplus select distinct !!

Title: RE: [Q] need help on SQLplus select distinct !! shouldn't that be select distinct employee_id from emp / ?? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email

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

You got an extra comma in your statement. Btw, check your statement construction, you probably want the subquery named as employee not hiredate column.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 5:59 PM I

RE: [Q] need help on SQLplus select distinct !!

Mike, You really don't need to in-line view for this. I'm also not sure what exactly you are trying to do. You could: select distinct employee_id, lname, fname, mi, hiredate from emp or select distinct employee_id from emp what exactly are your trying to get? Distinct employee_id's?

RE: [Q] need help on SQLplus select distinct !!

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,

RE: [Q] need help on SQLplus select distinct !!

Select distinct employee_id||lname|fname|mi||hiredate as employee from emp -Original Message- Sent: Tuesday, September 23, 2003 5:00 PM To: Multiple recipients of list ORACLE-L I plan to select distinct data from table. anyone has suggestion? Thanks. select distinct employee

RE: [Q] need help on SQLplus select distinct !!

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" [EMAIL PROTECTED] wrote: Are you doing homework...?Shame on you-Original Message-Sent: Tuesday,

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 [EMAIL

RE: [Q] need help on SQLplus select distinct !!

select distinct column1, columnn2 , ... from table; Stephane -Original Message- mike mon Sent: Tuesday, September 23, 2003 11:00 AM To: Multiple recipients of list ORACLE-L I plan to select distinct data from table. anyone has suggestion? Thanks. select distinct employee