---
title: "SQL-sats fungerar inte i MySQL"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/55202-sql-sats-fungerar-inte-i-mysql"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "i-or"
published: "2002-10-05T19:20:38.000Z"
updated: "2002-10-05T19:41:28.000Z"
replies: 2
views: 197
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/databaser-sql/55202-sql-sats-fungerar-inte-i-mysql"
---

# SQL-sats fungerar inte i MySQL

## #1 — i-or, 2002-10-05T19:20Z

Hur ska jag göra om denna SQL-sats så att den fungerar i MySQL:

```
SQL = "SELECT Max(C) AS f_max FROM (SELECT Count(*) AS C FROM t_diaryworkouts WHERE f_runner = " & Request.QueryString("ID") & " GROUP BY Year(f_date), Month(f_date))"
```

 

Felmeddelande:

Microsoft OLE DB Provider for ODBC Drivers fel '80040e09' 
\[TCX\]\[MyODBC\]You have an error in your SQL syntax near 'SELECT Count(\*) AS C FROM t_diaryworkouts WHERE f_runner = 1 GROUP BY Year(f_dat' at line 1

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

## #2 — LarsG, 2002-10-05T19:38Z

```
SQL = "SELECT Count(*) AS C FROM t_diaryworkouts WHERE f_runner = " & Request.QueryString("ID") & " GROUP BY Year(f_date), Month(f_date) order by c desc limit 1"
```

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

## #3 — i-or, 2002-10-05T19:41Z

Tack så mycket för det snabba svaret!

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/55202-sql-sats-fungerar-inte-i-mysql