---
title: "denna sql-sats till mysql"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/45716-denna-sql-sats-till-mysql"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "ampy"
published: "2002-06-12T15:58:16.000Z"
updated: "2002-06-12T16:23:51.000Z"
replies: 2
views: 183
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/45716-denna-sql-sats-till-mysql"
---

# denna sql-sats till mysql

## #1 — ampy, 2002-06-12T15:58Z

```
query2 = "select top 10 skribent,avg(len(meddelande)) as averageLength " & _
" from forum inner join affar on forum.skribent_id = affar.medlemsid " &_
" where tecken = 'ja' " & _
" group by skribent order by 2 desc"

set rs = connect.execute(query2)
c = 0
if  not rs.eof then
response.write "De 10 som har mest tecken per inlägg: <br>"
do while not rs.eof
c = c + 1
response.write "<b><font color='#BE0202'>" & c  & ".</font></b> " & rs("skribent") & " <font color='#676767'>(" & round(rs("averageLength"),2) & " tecken" & ")</font><br>"
       
if c = 10 then exit do
rs.movenext
loop
end if
```

Hur skriver man så att denna SQL-sats funkar till en MySQL-databas?

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

## #2 — LarsG, 2002-06-12T16:14Z

```
query2 = "select skribent,avg(char_length(meddelande)) as averageLength " & _
" from forum inner join affar on forum.skribent_id = affar.medlemsid " &_
" where tecken = 'ja' " & _
" group by skribent order by 2 desc limit 10"
```

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

## #3 — ampy, 2002-06-12T16:23Z

&nbsp;

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/45716-denna-sql-sats-till-mysql