Re: QUERY HELP NEEDED

fwdkhan_at_gmail.com wrote:
> Hi
> sorry for the late reply. One thing i forget to mention is that i am
> using MS SQL Server 2000 and when i use max(count(column_name)) it
> gives me error msg CANNOT PERFORM AN AGGREGATE FUNCTION ON AN
> EXPRESSION CONTAINING AN AGGREGATE OR A SUBQUERY and also there is no
> RANK() function available.

Very simply:
Oracle <> SQL Server

Go to:
http://msdn2.microsoft.com/en-us/library/ms203721.aspx

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org