Home » RDBMS Server » Server Administration » Re: retriving last 10 rows
Re: retriving last 10 rows [message #374655] Fri, 22 June 2001 19:47
palanikarupaiyan@hotmail.
Messages: 18
Registered: June 2001
Junior Member
Hi there is something called RecCount or RowCount builtin fuction... which return total # of rows the sql statement suppose to return...
so
write your sql like
select * from emp
where RowCount() <= 10
order by Desc.

Hope u will get it done.
Palani.

Report message to a moderator

Previous Topic: Joining Multiple Tables
Next Topic: Entering a character return in a memo field
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 03:51:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.