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

Unable to customise toolbar in FCK
Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.

we have to suppl

filesize() returns 0
I have a socket program that runs in an infinite loop, listening for connections, in this socket I h

Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at

Displaying data from MySql a different way
Hi all,
I'm pretty new to php and MySql and have hit a problem.

I am able to display data

Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

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

How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

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