Re: Alternative for TOP

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 08/03/04


Date: Tue, 3 Aug 2004 11:22:25 +0200

student
SET ROWCOUNT 10

"student" <agarwalp@eeism.com> wrote in message
news:elD5A8SeEHA.2376@tk2msftngp13.phx.gbl...
> Hi,
>
> Is there any alternative for TOP clause apart from Cursors. I mean suppose
i
> want to list down the top three values from a resultset, how do i do
without
> TOP Clause.
>
> Thanks
>
>



Relevant Pages

  • Re: Questions about Mandarin Chinese syntax, etc.
    ... If there are any native speakers of Mandarin Chinese reading this, ... student doing research on Chinese and relative clause constructions.) ... I yesterday meet DE like go concerts DE person is Zhangsan. ... could you have [relative clause DE] ...
    (sci.lang)
  • Re: Lookup/Linking Help Desperately Needed
    ... I put the where clause in there ... the WHERE clause in your query is why the student ... >when you enter a discharge date. ... >> disappears completely. ...
    (microsoft.public.access.gettingstarted)
  • Re: select qry - need an alternate way
    ... My requirement is to select the data from the EMP table itself. ... that you are a student or engaged in some form of Oracle education. ... point of the WHERE clause. ... selecting the recordbut rather where you filter which records from ...
    (comp.databases.oracle.misc)
  • Help Understanding nanodehanai ...なのではない
    ... I hope that somebody will be able to help a student understand the ... following sentences seen on Jim Breen's site. ... understanding how to interpret the "...なのではない..." ... occur in clause after clause after clause are a real pain! ...
    (sci.lang.japan)
  • Re: Print the current record shown on form using a report
    ... > To print a student report the users click on a command ... The current report associated with the ... > command button is based on a query that asks for the Student ID. ... Where Clause + Restrict data to a subset of records' ...
    (microsoft.public.access.forms)