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

* Gridview and Detailsview in UpdatePanel, insert mode problem
I have a GridView and DetailsView working together. When a record from Gridview is selected, Detail

Procedural to OOP
John Kleijn said that to avoid writing "crappy code", we should learn OOP and common OO pr

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

Allowing ' and "
Hello everyone,

I am creating a form where users submit information to go into a database. I

$_FILES array
Ok,

I just started experimenting with PHP today. My goal right now is to have people be able

Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the 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

Help: problem with Headers to download PDF file
Hi,

I'm trying to implement a script where when a user clicks a link he gets a PDF file to op

Best way to cross matching large datasets
Hi,

Im running a script where am I cross matching about 200 000 data sets with each other. Ea

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