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

php ajax - two drop down list with a submit button
i have created a form with 2 drop-down list and a submit button. I would like to know how to pass th

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

Delete HTML file after loading
I have limited experience with php and its been a year or two since I've last used it. I have a sma

why does my session end?
my connect.php starts the session just so you know
i can navigate arround my site fine except whe

VAT
how should I deal with VAT?

if I have a product that costs £5.00 and VAT @ 17.5% (£0.87

PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a

I am stumped
OK. Here is what I am trying to do. I have the conditions set, and if the conditions are met, I want

List/Menu Box
On an edit page when you want something to select what a user has previously selected from the datab

How to have a log of all the status a VIM document had been ?
Hi guys,

I’m using SAP Invoice Management plugin and the /OPT/VIM_ANALYTICS transa

convert static html data into dynamic
hi all

i need to convert a website which has static above 2000 articles into dynamic and add

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