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

isset undefined variable
Hi all,

Hope someone can point out the obvious. I've a log in script, if you dont enter a use

Display a default image
I am trying to display generic image for items that don't have one, but I can't get it to display.

Streaming local file from PHP while it’s been written to by a CURL process
I am creating a simple Proxy server for my website. Why I am not using mod_proxy and mod_cache is a

GET * FROM _____ Except?
I have a site that is for stock photography.

This section of the code calls images to display

timezone change with date()
so i put all my times for posts in my made from scratch forum(not phpbb3 or sm)
in my mysql db u

RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai

displaying email without attracting a ton of spam
Hello,

this is maybe the wrong place to ask.
How would you display an email address on a w

IF STATEMENT HELP
Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table w

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

Is there a way to override built in php functions without APD?
I am trying to use the
rename_function()
override_function()
options that are built into

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