---
title: "SQL1 = \"SELECT TOP 1 FROM salj\""
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/54220-sql1-select-top-1-from-salj"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "soffan76"
published: "2002-09-25T08:17:39.000Z"
updated: "2002-09-25T08:33:11.000Z"
replies: 4
views: 254
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/54220-sql1-select-top-1-from-salj"
---

# SQL1 = "SELECT TOP 1 FROM salj"

## #1 — soffan76, 2002-09-25T08:17Z

Hej!

Jag vill hämta upp senaste inlägget i tabellen salj.

```
SQL1 = "SELECT TOP 1 FROM salj"
Set RS1 = conn.Execute(SQL1)
```

Och sedan visa den:

```
<b>Senaste säljesannonsen:</b>
<br>
<a href="visa_salj.asp?id= <% =RS1("IDNum")  %>" >
```

Men då får jag detta felmeddelande:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

\[Microsoft\]\[ODBC Microsoft Access Driver\] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. 

/intra/annonser.asp, line 44 

Varför då?

Permalänk: https://www.webforum.nu/p/54220

## #2 — OveRRidE, 2002-09-25T08:19Z

Du måste ange vilka kolumner du skall hämta också. I mitt fall alla, ( \* ).

```
SQL1 = "SELECT TOP 1 * FROM salj"
```

Permalänk: https://www.webforum.nu/p/796399

## #3 — Jesper T, 2002-09-25T08:20Z

Asterixen måste vara med:

SQL1 = "SELECT  TOP 1 \* FROM salj"

Permalänk: https://www.webforum.nu/p/796401

## #4 — LarsG, 2002-09-25T08:26Z

Om du vill ha senaste så måste du ha order by med

```
select top 1 * from salj order by bestDatum desc
```

Permalänk: https://www.webforum.nu/p/796407

## #5 — soffan76, 2002-09-25T08:33Z

Tackar så mycket! Nu funkar det fint.

Permalänk: https://www.webforum.nu/p/796412

---

Tråden på webben: https://www.webforum.nu/amne/asp/54220-sql1-select-top-1-from-salj