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

Problems with returning true or false in eval()'d code
Hi guys,

Would appreciate some help with a problem when running eval() on a function that sho

New Search Engine problem
Hey everyone,

I have a ZIP Code Radius search engine already functional. it displays all of t

ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al

help with Get_
ok some how this is not working i am not sure what i am doing wrong here but what this does is when

Update Myspace status with CURL
Logging in:

Code: <?php

class Myspace
{
function login($username, $pa

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

PHP mail() rejected by SMTP
I'm currently working on a newsletter application which is installed on a windows 2003 server runnin

Date Question
I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, ho

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

C - Reading a file into a byte array
Hi,

I'm trying to read a file into a byte array in C. I have to use C as this is for a loadru

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