distinct rows


Posted on 16th Feb 2014 07:03 pm by admin

Hi
version 10.2.0.3

I have a query output something like the following

ID name
1 aaaa
1 axbd
1 adga
2 sgfd
2 dfdg
3 dfdff
4 dfdff

my desired result is

ID name
1 aaaa
2 sgfd
3 dfdff
4 dfdff

could yo help me please on the query please?

Thanks

No comments posted yet

Your Answer:

Login to answer
305 Like 13 Dislike
Previous forums Next forums
Other forums

Legal Issues for SAP ERP o ERP in general
Hi experts,

Can someone please help me finding some documentation about legal issues tha

C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.
What libr

explode() function problem maybe
Hi I'm having trouble searching my database. When I type two words in the search field it only searc

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

Looking for help reading a .txt or .ini file and outputting the info.
I have a file called Info.ini and It has the following info:
Code: [General]
Online=0
I wou

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

Match stored value with the current value in a loop
Hello,

I have a MySQL db were I store articles in.

I have a form to fill these article

How can I Compare two xml documents?
Hi all,

I am doing a POC for my project and I am using XE database 10g version.

Database/Table Collation
What is the Database, and table collations used for? i don't understand what there used for since co

help with image text
Hi ...

see i need the text of the name and number to start in the center and always be in the

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash