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

SCO Unix
I know this might not be the place to ask, but, can anyone tell me if SCO Unix comes with PHP built

Having Problem with Date
l have a submit buttom where user have the possibility to add a date to specify when his message s

Javascript or not?
How many people prefer javascript/ajax sites? How many prefer the good old fashion straight php sit

Multidimensional array problems in $_POST
I'm having trouble with a three-dimensional $_POST array. It starts as a two-dimensional array on th

grouping within a foreach?
hello all,

I currently have a list of products spit out from my db via a foreach loop. Right

Php - mysql select?
hi, i have this code:

Code: <?php
session_start();
// dBase file
include &quo

Login Issue's
Code: <?php
$file = fopen('user.txt', 'r');

/* Set login to false initially */

Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields

FTP Programs
Here is a list of commonly suggested FTP Programs to use:

FileZilla
SmartFTP
CuteFTP

some questions
Hello,

I am looking for the answers for following questions:

1) Does PHP support overl

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