sql wont work

mrbear · #1 (**permalink**) 03-24-04, 00:48

i posted a question about how to display the top 5 highest figures in the column, i was given this solution

Select columns
from
(select columns, RANK() OVER (ORDER BY column DESC) RN
from tableA
) V
where V.RN <= 5

but it did not work, i'm using the vb.net and it wont recognize the RANK() OVER and wat does it mean

r937 · #2 (**permalink**) 03-24-04, 03:16

access or sql server?

Code:

select top 5
       thecolumn
  from thetable
order by thecolumn desc

mrbear · #3 (**permalink**) 03-24-04, 09:16

im using sql server

r937 · #4 (**permalink**) 03-24-04, 09:18

sql server supports the TOP syntax i gave

Internet Services

Web Development

Digital Marketing

Consumer Tech