Hi guys.. rownum is virtual column we con't use max(rownum) i t wil

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

Question Posted / suneelkumar

Answer Posted / suneelkumar

Hi guys..

rownum is virtual column we con't use max(rownum) i t will
give the error unknown colum...

so by using cursor we can count

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Enlist the advantages of sql.

949

How do I debug a stored procedure?

1049

Define union, minus, union all, intersect ?

958

What are the steps for performance tuning.

1282

Explain cursor types?

964

what is the difference between nested subquery and correlated subquery?

996

What is sql injection vulnerability?

880

Why do we use sql constraints? Which constraints we can use while creating database in sql?

984

What is the sql*loader? : aql loader

1018

How do I write a sql query in pgadmin 4?

933

How do you explain an index?

1231

How many functions are there in sql?

968

Explain commit, rollback and savepoint.

946

How do you rename a table in sql?

1045

What is a database? Explain

1060