Row Count

[hameja]

Hi People

Is there any function in Oracle like Row count

 

[alexhu]

Do you mean as in

select count(*) from <tablename>;

?

Alex

 

[hameja]

No I mean

select * from tbl where rowcount </> number

 

[SantaMufasa]

Hameja,

You can say:

select * from tbl where [b]rownum <=[/b] <some number>;

...but due to the nature of the ROWNUM expression, you cannot make comparisons (using the above syntax) with the ">" comparison operator and achieve the results you want. So, in summary, always use "<" or "<=" for your ROWNUM comparison operator.

(There are tricks to use "=", ">=", and ">" with ROWNUM, but that is a topic we'll address if you ask for it.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.