Display 5 top records using SQL

[Thanasis \(sch\)]

Hi to every one,
what i want to achieve is to display the first 5 records (only one
field-lastname ) from a select query.
I tried something like below but it didn't work.


SELECT TOP 5 lastname
FROM Results
ORDER BY hiredate DESC



Thanks in advance
thanasis

 

[Jon Spivey]

Hi,
There's nothing wrong with that SQL. What happens, or doesn't happen?

 

[Thanasis \(sch\)]

Hi,
There's nothing wrong with that SQL. What happens, or doesn't happen?

it displays all the records (not only the first 5)


thanasis

 

[Kevin Spencer]

What database are you using?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Big things are made up of
lots of little things.

 

[Thanasis \(sch\)]

ms access

What database are you using?

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Big things are made up of
lots of little things.

 

[Thanasis \(sch\)]

What database are you using?

Hi,

i'm using ms access 2000 and FrontPage 2003 (DataBase Interface Wizard)


Thanks

Thanasis

 

[Kevin Spencer]

Well, as Jon said, there's nothing wrong with the SQL statement. There must
be something wrong with your code. You were'nt very specific about that.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Big things are made up of
lots of little things.

 

[p c]

Yiasou Thanassi.

To febug the porblem, in ASP code do a response write of the SQL
statement at the line before it execcutes. To verify that is the same
one sent to the DB. E.G., if you are using strSQL:

response.write "<br>SQL: " & strSQL


...PC