Re: TOP Clause

Tech-Archive recommends: Fix windows errors by optimizing your registry

no, the only aggregate functions supported in SQL CE are
AVG, COUNT, MAX, MIN, and SUM.

SQL Mobile (next version of SQL CE) is supposed to
include support for TOP but it's not there in the betas yet.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Steve B." <steve_beauge@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OC%23t515iFHA.1044@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> Is there any way other than coding to get the same result than the TOP
> clause available only on desktop SQL Server version ?
>
> If I query the DB using "SELECT TOP 3 * FROM anytable", I get a parsing
> error on TOP.
>
> Thanks,
> Steve
>


.

Relevant Pages

  • Re: Simple sql question, I think.
    ... SQL> select count, avgfrom emp; ... SQL> select deptno, count, avgfrom emp group by ... SQL> comp avg of avgon report ...
    (comp.databases.oracle.server)
  • STORE.EXE using all memory.
    ... SQL on the box as well? ... store is and how big this SQL database is. ... restart. ... Grisoft (the authors of AVG) ...
    (microsoft.public.exchange2000.information.store)
  • Newbie Needs Help - Conversion
    ... Using SQL 2005 - I have a column in my table named Q1 ... 'Above Avg' to data type int." ...
    (microsoft.public.sqlserver.programming)
  • Multiple Aggregation causes error
    ... I receive Msg 245, Level 16, State 1 when i try AVG on more than one column within my select statement. ... the SQL Select statement is quite complicated so i have included it below: ... (select VesselID from ...
    (microsoft.public.sqlserver.programming)
  • RE: Calculated fields in main form based on criteria in sub form
    ... I've changed the SQL by droping the WHERE statement and setting GroupBy to ... NE Sum Query (uses information from the subform, ... other queries differ in what Quadrant equals) ...
    (microsoft.public.access.forms)