How to count the no of records of a table without using
COUNT function?
Answer Posted / kart
using select command
select * from xxx; we will get the no of rows at bottom
if the feedback is unset
then use the plsql with cursor;
select rownum from table; the last value
is the number of records
| Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
How to write a query to show the details of a student from students table whose
What is the difference between alter trigger and drop trigger statements?
What is sql architecture?
explain advantages of innodb over myisam. : Sql dba
How do I add a primary key to a table?
How do I find duplicates in two columns?
Is foreign key mandatory?
Explain alias in sql?
How do you take the union of two tables in sql?
what is an index? : Sql dba
What is inner join in sql?
Can we update views in sql?
What does desc stand for?
what is the use of set statement in tsql? : Transact sql
what is unique key constraint? : Sql dba