How do you select the Top n records in a query or Stored Procedure.
my current Stored Procedure is as follows:
create Procedure nspTopDTMAchines (TopRecords Integer)
Returns (MachineName Varchar(10), MachDownTime Integer)
as
begin
for
Select dtd.MachineName, Sum(dtd.DownTime)
FROM nvDownTimeDetails dtd
GROUP BY dtd.MachineName
ORDER BY 2 DESC
Into :MachineName, :MachDownTime
do suspend;
end;
I need to use the parameter TopRecords to determine how many Records to return.
Thanks,
matchbx
Start Free Trial
