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 you join views in sql?

531

Is postgresql a nosql database?

525

What are string functions in sql?

668

what is a control file ? : Sql dba

569

Why is sql*loader direct path so fast?

593

Explain the difference between drop and truncate commands in sql?

525

how to use 'mysql' to run sql statements? : Sql dba

533

How do I use google cloud in sql?

530

What is AUTH_ID and AUTH_USER in pl/sql ?

1682

How to fetch alternate records from a table?

673

How many sql are there?

504

Does a join table need a primary key?

522

Explain lock escalation? : Transact sql

695

What are properties of the transaction?

552

What is the use of double ampersand (&&) in sql queries? Give an example

600