With out using count() function. How to the find total
number of rows in a table?
- 6 Answers
- 11813 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
What is trigger types in sql?
What is the least restrictive isolation level? : Transact sql
tell us something about heap tables. : Sql dba
What is benefit of creating memory optimized table?
What is a primary key called that is made up of more than one field?
what is schema? : Sql dba
What is difference between nchar and nvarchar?
How many types of cursors supported in pl/sql?
what is a materialized view? : Sql dba
what is the difference between primary key and unique key? : Sql dba
How global cursor can be declare with dynamic trigger ?
What is a heap in sql?
how to escape special characters in sql statements? : Sql dba
What are the types of functions in sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
