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

Your Answer:

Login to answer

Other forums

Something like an INI editor or a DelimitedText-Editor
Hi all,

Am very, very, very new to PHP and not sure if I should be posting this to a Javascri

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

Problem with the Update command used with a sqldataadapter
I'm connected to a database on an SQL Server and I'm using a sqldataadapter, sqlconnection, sqldatas

Refining of search Criteria
Dear Friends

I need a help, I have a search page which of cars related, which has different s

i want run some web server under the ip sharer
hello i want run some web server under the ip sharer
my ip is floating ip but it doesnt matter

opening a window with after form submission
I know this this forum has nothing to do with JS, but i'm trying to use it with my php script.
<

Bandwidth monitoring?
Hi guys,

I need a little information I have written a php app and I occurred to that I need

Echoing a Variable from a Object
How do I get a variable from the new User Class to echo out in this clasS?

class MyApp
{

A href problem under php
Hello...

I tried to explain the issue in an earlier post.. but was not clear enough....

socket makes browser hang...
I have a socket server, and I am having a problem at the moment...

A browser sends a http hea