MySQL Forums
Forum List  »  Newbie

Create a sortid
Posted by: Astrid M
Date: March 08, 2016 12:04AM

Hi,
I am pretty new to mysql and on top of that is too early to think :)

I am trying to build a column with a sort id, and window's functions don't work here.

basically how would I translate.

row_number() over (partition by leadID) as SortID

thanks!!!
Astrid

Options: ReplyQuote


Subject
Written By
Posted
Create a sortid
March 08, 2016 12:04AM
March 08, 2016 01:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.