select rownum from tablename;

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

Question Posted / ramachandran

6 Answers
12959 Views
I also Faced
E-Mail Answers

Answer Posted / ramachandran

select rownum from tablename;

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you use a while loop in pl sql?

1021

Explain what is a column in a table?

1117

Does pl/sql support create command?

1124

What is auto increment feature in sql?

1131

what is self join and what is the requirement of self join? : Sql dba

1145

Can you do multiple joins in sql?

1056

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1049

What are the two virtual tables available at the time of database trigger execution?

1231

What is %s in sql?

1043

Is not null in sql?

1004

Where can I learn sql for free?

1000

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

1081

What is the difference between left and left outer join?

956

Explain raise_application_error.

1108

What is your daily office routine?

2279