display the nth row

http://marist89.blogspot.com/2005/09/top-n.html

Quote:

---

Originally Posted by PAVB

Did that solved your issue?

---

yeahh dear....by the way I put the wrong code and edited it.

Jefff, why cant i open ur link? it keeps on telling me "This domain is no longer parked." .....maybe i got virus in my pc:confused:

Can any one print marist link solution pls. thanks

Quote:

---

Originally Posted by jennifer2007

Jefff, why cant i open ur link? it keeps on telling me "This domain is no longer parked." .....maybe i got virus in my pc:confused:

---

dunno, works for me.

Quote:

---

Can any one print marist link solution pls. thanks

---

That's not cool, I wouldn't be happy about that.

Quote:

---

Originally Posted by jennifer2007

"This domain is no longer parked." .....maybe i got virus in my pc:confused:

---

:rolleyes: weird!

Sorry dear I dont want to embarrass Jeff ;)

ok its displaying now....but.... it is using ORDER BY:confused: i think i dont
understand it well or it doesnt fit to my requirement? my solution works
fine but I dont wanna insert lots of null values to a temp table:rolleyes: