Roger Baklund wrote:
>>hi there.. no solution from me, but I'm also interested in this type of
>>query (although I only want 1 for each "lang")
>>
>
> If you only want one row for each "lang" you can do it using GROUP BY...
> SELECT * FROM table GROUP BY lang
Whoa. Watch out. You can omit co
> hi there.. no solution from me, but I'm also interested in this type of
> query (although I only want 1 for each "lang")
If you only want one row for each "lang" you can do it using GROUP BY...
SELECT * FROM table GROUP BY lang
Often you would want to use some GROUP BY functions: MIN(), MAX
...
/Christian
- Original Message -
From: "Jacob Friis Larsen" <[EMAIL PROTECTED]>
To: "Brett Error" <[EMAIL PROTECTED]>; "Mysql maillist"
<[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 8:11 PM
Subject: RE: select 10 of
ysql maillist
> Subject: RE: select 10 of each
>
>
> You'll have to issue two separate queries:
>
> "select * from table where lang=1 limit 10" and "select * from table where
> lang=2 limit 10"
>
> -Original Message-
> From: Jacob Fri
You'll have to issue two separate queries:
"select * from table where lang=1 limit 10" and "select * from table where
lang=2 limit 10"
-Original Message-
From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 11:46 AM
To: Mysql maillist
Subject: select 10
