With out using count() function. How to the find total
number of rows in a table?
Answers were Sorted based on User's Feedback
Answer / subbarayulu neela
select max(rownum) from table-name;
Here rownum is a keyword which can gives unique number for
individual rows.
Is This Answer Correct ? | 35 Yes | 2 No |
Answer / manjunath u
rownum is one of the option, can deal with sequence also
Is This Answer Correct ? | 4 Yes | 2 No |
What is diff between bulk collect and forall
explain the difference between bool, tinyint and bit. : Sql dba
What is where clause in sql?
if i perform any operation on views such as insert, delete etc will my base table get affected?????
What is compilation error in pl sql?
How do you remove duplicate records from a table?
Main diff between varray and nested tablea
What is the unique index?
in procedure how to return a value
what is an associative array with example?
What is mutating error in pl sql?
What is the least restrictive isolation level? : Transact sql