TOP clause

  • Thread starter Thread starter Ritesh Jain via DotNetMonster.com
  • Start date Start date
R

Ritesh Jain via DotNetMonster.com

Hi,

Not sure .try with

SELECT TOP 10 * afieldhere
FROM atablehere
ORDER BY afieldhere DESC


Reagrds,
Ritesh
 
And the database is?
It depends on the database if it supports such command.
 
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
 
gg, Sybase doesn't support it (too much of sqlserver)
Thx for your help

Miha Markic said:
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

VM said:
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
Click to expand...
Click to expand...
 
Back
Top