select rownum from table

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

Question Posted / sudhakar & co

11 Answers
29170 Views
TCS, Tesco, I also Faced
E-Mail Answers

Answer Posted / sudhakar & co

select rownum from table_name;

Is This Answer Correct ?

1 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

992

Can a foreign key be null?

1142

How can you know that statistics should be updated?

1125

explain the advantages and disadvantages of stored procedure? : Sql dba

1059

What are pl/sql cursors?

1098

Explain the uses of database trigger.

1172

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2066

Is sql a dbms?

1059

Advantages and disadvantages of stored procedure?

1165

How do I sort a table in sql?

1080

What is sql stand for?

1033

How many row comparison operators are used while working with a subquery?

1070

List the various privileges that a user can grant to another user?

1088

How do we accept inputs from user during runtime?

1116

Can we change the table name in sql?

994