Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Avoid duplicate records in select statement

944832Jul 8 2014 — edited Jul 8 2014

HI,

I have given below query but i am getting the duplicate records also. Pls suggest how can i avoid the duplicate records in select statement...

select max(column_name) from table_name1,table_name2

where column1=column2 and column3=344 and column3='D' group by column5

Thanks,

Venkat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2014
Added on Jul 8 2014
5 comments
11,720 views