List:General Discussion« Previous MessageNext Message »
From:Slackli User Date:September 10 2009 9:43am
Subject:how to query this
View as plain text  

sorry I'm not good at SQL statement.
I have a table, whose stru is like:

id        value
1          33
2          987
3          10
4          22

I want to get the max value and the corresponding id, using this sql:

select max(value),id from table;

but it won't work.

so what's the correct syntax? Thanks.
how to query thisSlackli User10 Sep
RE: how to query thisJohn Daisley10 Sep
  • Re: how to query thisWolfgang Schaefer10 Sep
    • Re: how to query thisSlackli User10 Sep
      • Re: how to query thisClaudio Nanni10 Sep