select max(rownum) from table

How to count the no of records of a table without using
COUNT function?

Question Posted / kart

Answer Posted / kart

Is This Answer Correct ?

65 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between triggers and constraints?

919

What is rank function in sql?

961

What is an emotional trigger?

930

Describe different types of general function used in sql?

977

How is debugging done?

919

How would you pass hints to the sql processor?

920

What is database white box testing and black box testing?

1045

What is sql engine in oracle?

927

What is a temporal table?

880

Can we use loop in sql?

922

what is a unique key ? : Sql dba

1025

What is full join?

896

What are local and global variables and their differences?

1045

Is it possible to pass parameters to triggers?

1030

Can we create index on primary key?

913