Quoting Ernest E Vogelsinger <[EMAIL PROTECTED]>:
> At 18:29 20.11.2002, Ryan Gallagher said:
> [snip]
> >SELECT * FROM identifisering as i
> >WHERE i.identifiseringid = (
> >SELECT MAX(ii.identifiseringid) AS maxIdentifiseringid
> >FROM identifiseri
At 18:29 20.11.2002, Ryan Gallagher said:
[snip]
>SELECT * FROM identifisering as i
>WHERE i.identifiseringid = (
>SELECT MAX(ii.identifiseringid) AS maxIdentifiseringid
>FROM identifisering as ii
> )
>GROUP BY dprosjekt
>
>Now that I look at it, you
Quoting Ernest E Vogelsinger <[EMAIL PROTECTED]>:
> At 04:57 18.11.2002, Lars Espelid said:
> [snip]
> >I tought this would work, but it won't:
> >
> >SELECT * FROM identifisering as i
> >WHERE i.identifiseringid=(SELECT MAX(ii.identifiseringid)
> >FROM iden
At 04:57 18.11.2002, Lars Espelid said:
[snip]
>I tought this would work, but it won't:
>
>SELECT * FROM identifisering as i
>WHERE i.identifiseringid=(SELECT MAX(ii.identifiseringid)
>FROM identifisering as ii
>GROUP BY dprosjekt);
>
>also tried:
>
>SELECT *
you can use temporary tables:
CREATE TEMPORARY TABLE tmp_name SELECT SELECT MAX(ii.identifiseringid)
AS max_ii
FROM identifisering as ii
GROUP BY dprosjekt
then:
SELECT * FROM identifisering as i, tmp
WHERE i.identifiseringid='123' AND i=identifiseringid=tmp.max_id;
Lars Espelid wrote:
Hello
5 matches
Mail list logo