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!

select two distinct columns and other non-distinct

don123Jun 19 2013 — edited Jun 20 2013

hi,

I want two distinct columns (X, Y) along with other columns (GID, CODE, TID). Please help me on how to do this.

In the below example, first and last have same X and Y and distinct should be applied on this two columns and select other columns (GID, CODE, TID) as well in the query.


GIDCODETIDXY
730MKPR12.35653648.72052
730MKPR22.35562748.72069
730MKPR32.35562848.72264
730MKPR42.35577348.72239
730MKPR52.35581648.72229
730MKPR62.35583248.72225
730MKPR72.35593948.72201
730MKPR82.35603948.72177
730MKPR92.35608848.72165
730MKPR102.35614748.72151
730MKPR112.3561948.7214
730MKPR122.3562648.72123
730MKPR132.3563248.72111
730MKPR142.35638548.72099
730MKPR152.35653648.72052
This post has been answered by Mahir M. Quluzade on Jun 19 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2013
Added on Jun 19 2013
11 comments
6,311 views