[Haskelldb-users] best way to implement this query?

[Jeremy S. <Jer...@li...>]

Hello,

 I am not quite sure what the best way to do the following in haskelldb
 is:

Here is the query in SQL:

 select column1 from table1 where column2 =3D (select max(column2) from
 table1);

 Basically, I want to find the value in column1 that is in the same row
 as the
maximum column2 value. In this case, column2 is a unique key.

 I could do this as two seperate queries haskelldb,=C2=A0 one to find the m=
ax
 column2 value,
 and a second query to find the corresponding column1 value -- but it
 would be nice to
 do it all in one step. I imagine I might also be able to hack something
 up by using sort
 and top -- but that seems a bit hackish when the actual SQL I want to
 generate is
pretty straight forward.

Any ideas?

Thanks!
Jeremy Shaw.