Wednesday 15 September 2010

sql server 2012 - Extracting second value from ordered list -


The following gives me a list of countries in alphabetical order I

how can I change it Instead of returning the complete list, would it return to another country in this list? In the context of our cube, it will only be the result for aland island . [Geography] .MEMBERS [Geography]. [Geography] .ROS, [Remembrance] on [existing tower]. [Default Mean Name] [

  SELECT ORDER ([Geography] [Geography]. MyCube]    

You can use the function; if I'm well Remember that it is 0-based:

  ORDER ([geolocation]. [Geography] ...) (1)    

No comments:

Post a Comment