rownum is one of the option, can deal with sequence also

With out using count() function. How to the find total
number of rows in a table?

Question Posted / manjunath u

Answer Posted / manjunath u

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can triggers stop a dml statement from executing on a table?

1101

what are the advantages a stored procedure? : Sql dba

978

How does an execution block start and end in pl sql?

954

What is clustered and nonclustered index in sql?

944

what is cross join? : Sql dba

1004

Why is sql*loader direct path so fast?

1107

Why do we use joins?

1043

How do I create a memory optimized filegroup?

968

How to select 10 records from a table?

1159

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1109

Why are aggregate functions called so?

951

What is the maximum rows in csv?

927

how to use like conditions? : Sql dba

1112

What is a dirty read sql?

1149

What is compilation error in pl sql?

983