sql server

Page 1 of 1

1 Replies - 624 Views - Last Post: 29 November 2012 - 10:23 PM Rate Topic: -----

#1 lthemi02  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 26-November 12

sql server

Posted 29 November 2012 - 04:57 PM

i have to count some distances in sql server and i have to get the 10 longest distances. but if i have a distance with the same value of another distance i have to get 11 distances. do you know how this works?
Is This A Good Question/Topic? 0
  • +

Replies To: sql server

#2 rnty  Icon User is offline

  • D.I.C Head

Reputation: 17
  • View blog
  • Posts: 131
  • Joined: 14-August 12

Re: sql server

Posted 29 November 2012 - 10:23 PM

You can use "select top n with ties..." but that will select only the records matching(if present) row n.
But this solves it
http://stackoverflow...ne-from-each-ca
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1