Jump to content

Search the Community

Showing results for tags 'analytics function'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type



Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 1 result

  1. I have a table like this: ID | Val | Ord ---------------------- 1 | 1000 | 1 1 | 1000 | 2 1 | 2000 | 3 1 | 2000 | 4 1 | 2000 | 5 1 | 1000 | 6 1 | 1000 | 7 I want to make a SELECT that will return Sample output: ID | Val | Ord ---------------------- 1 | 1000 | 2 1 | 2000 | 5 1 | 1000 | 7 the output I can produce is ID | Val | Ord ---------------------- 1 | 1000 | 7 1 | 2000 | 5 I would like to use the last_value function but I have problems when the value assigned to the same key repeats alternated with a different value How can I build this query? Thanks for your help Franz
×