• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Generalising Rownum for all DataBases

 
sreenath reddy
Ranch Hand
Posts: 415
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I have as issue with this rownum.This is supported in different forms in different databases like top in mssql ,limit in mysql and all..i want to genaralise this independent of the type of database because i want to run the query as i wont be knowing the type of the DB used by my user.

can anyone suggest a solution for this ? is there anyway of generating a series of numbers with the query by calling the function in that query repetitively ???


Regards
Sreenath
 
Tom Blough
Ranch Hand
Posts: 263
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The only way I can think of to be independent of specific implementations of rownum, it to implement your own ranking as a field in the data:

[code]
SELECT a.vendor_no, a.total, count(*) AS rank
FROM qryTopSuppliers AS a, qryTopSuppliers AS b
WHERE a.total <= b.total
GROUP BY a.vendor_no, a.total
ORDER BY 3;
[code]

rank will now contain a integer value you can use for your own purposes.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic