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

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

Question Posted / subashpanda

Answers were Sorted based on User's Feedback

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

Answer / sudhakar & co

select rownum from table_name;

Is This Answer Correct ?

1 Yes

12 No

More SQL PLSQL Interview Questions

What is the execution plan in sql?

What is a native sql query?

State the advatage and disadvantage of Cursor's?

Do you understand the meaning of exception handling?

If the base table structure is changed what will happen to join index????

What is an Exception ? What are types of Exception ?

What is the purpose of a sql?

What sql database should I use?

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

What has stored procedures in sql and how we can use it?

Does sql*plus have a pl/sql engine?

What is the difference between the Primary and Foreign key?

For more SQL PLSQL Interview Questions Click Here