Forum Discussion
Use RANKX with column ID or column not calculated
Hello everybody, I would like to know if I can use RANKX function with column ID or column not calculated ? If not, is there a solution to display the first ten rows of this table (knowing that I tri...
Anonymous you have to be very specific about what does the first ten-rows means? sorted by id? ascending or descending? If you want to keep the order the way it is then it is going to be a different solution. Always provide a context about your question.
Although solution amitchandak provided should work depending on what you are looking for.