Re: Help with SQL query

select *
from
(
select fname, lname, count(1) number_of_entries   from faq
 where entry_date > trunc(sysdate-8)
 group by fname, lname
 order by number_of_entries desc
)
where rownum = 1

"Graham" <gn_at_jan.ucc.nau.edu> wrote in message news:9kes5q$st0$1_at_usenet.nau.edu...
> Here is what I want to do in English, I would appreciate if someone could
> translate this into SQL for me.
>
> Select [fname], [lname] from faq where [fname] has most entries and
> [entry_date] > 8 days old
>
> [ ] denotes column, also available is the primary key [faq_id]
>
> Thanks
> Graham
>
>
>
Received on Sun Aug 05 2001 - 10:46:08 CDT