TOP clause

[Ritesh Jain via DotNetMonster.com]

Hi,

Not sure .try with

SELECT TOP 10 * afieldhere
FROM atablehere
ORDER BY afieldhere DESC


Reagrds,
Ritesh

 

[Miha Markic [MVP C#]]

And the database is?
It depends on the database if it supports such command.

 

[VM]

Hi,

How could I get this to work? I'm using oledb

SELECT TOP 10 afieldhere
FROM atablehere
ORDER BY afieldhere DESC

I'm getting an error parsing query.

TIA,
VM

 

[VM]

gg, Sybase doesn't support it (too much of sqlserver)
Thx for your help

And the database is?
It depends on the database if it supports such command.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

Hi,

How could I get this to work? I'm using oledb

SELECT TOP 10 afieldhere
FROM atablehere
ORDER BY afieldhere DESC

I'm getting an error parsing query.

TIA,
VM