| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: select count(*)
select col1, col2 , a from table1, (select count(*) a from table1)
/
On 10 Aug 1999 09:00:09 GMT, Norris <johnnie_at_cooper.com.hk> wrote:
>In SQL Server, I can do the following queries:
>
>select col1, col2, count(*) total_record
>from table1
>
>select col1, col2, (select count(*) from table1) total_record
>from table1
>
>In Oracle, how can I do that?
Received on Tue Aug 10 1999 - 04:38:51 CDT
 |
 |