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

Form always sends to error page...
Hello,
Any help will be greatly appreciated. I am having trouble getting multiple fields to be re

Problem with HTTP Caching...?
Hi there, im trying to implement caching. But it doesn't always work.
I post it here because ther

ASP.NET 2.0 - Enter Key - Default Submit Button
Hi,One of the most annoying things in developing web pages is handling the "Enter key" for form subm

How do I send data using an html link
Hi

If I have
<a href="main_file.php">

How do I send data t

How to implement HTTP connection timeout
Hi All,I would like to implement an HTTP connection timeout.

I am working on a application wh

$_POST
Hi, I have 2 seperate php files, and i want my $_POSt["fname"] To go into both of them, Fo

displaying unknown amount of results
I am reading a directory and getting a list of folders in the directory, I want to display the folde

Uploading files/images via forms
Hey all, I am building a database for work that will contain some minor data on plant species along

Frustrated php Newbie
First off, I am pretty much a PHP nub. I can read and understand the language (most of the time) so

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

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