SQL MAX.... quite limiting! 1

[fenneraj]

Hi, I have created a View (MAX_LIST) that shows an output like below.

FB_SN | MAX_CALLS
1 3
2 7
3 6

I am trying to write an SQL query that will output the the max from max calls and its corresponding FB_SN. Using the MAX in the select just presents me with the MAX Max_Calls value.

IDEAL OUTPUT:

FB_SN | MAX_CALLS
2 7

If anyone can help with this, i would be most grateful!

Regards
Andy Fenner

 

[r937]

select FB_SN
     , MAX_CALLS
  from MAX_LIST
 where MAX_CALLS =
     ( select max(MAX_CALLS)
         from MAX_LIST )

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)