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
Did you know?Explore Trending and Topic pages for more stories like this.

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

Need some ideas as to how to go about sorting this array...
Here's how the array's are created..

Code: <?php
while ($x = readdir($dp)) {

extract data
Code: <div class="post hentry uncustomized-post-template">

how can i make a .gif images for my site
Dear Friends ,

Pls solve my problem , I am starting making new site but i dont know how can i

parse error
On my local machine I keep getting parse error for my footer. When I put it online, it doesn't show

User feedback after MySQL query has been executed
Hi all, I've just registered on PHPFreaks because I've got a question that I simply can't work out b

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything

Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi

Retreiving objects from Sessions
Hi all,

I am getting really frustrated with storing and retreiving objects from a session. Bu

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