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

Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

How to display random record from table?
I have the following code:

Code: <?php
$display_block .= "<input type=

Session
I am having a little trouble with a session. Not sure if it is my browser or what. I know I do not

Is STL important?
I'm just starting programming and I've made it until the Standart Template Library. But the chapter

Setting/Modify Headers using mail() function
I have a question about setting email headers when using mail() in a php script.

When I send

Price in PR
Dear Experts,
Why we have to enter the price in the PR, and why there is no free goods indicato

add to sql result
ok see rite now my sites hit counter is counted from the mysql visitor log i need to clear it aft

Really need helps regarding Pagination with Sort
I need someone helps regarding pagination problem...i actually want to make my page limited to let s

how to validate date using javascript
I need to validate date in textbox using javascript..
The date is must be not greater than TODAY

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