How to count the no of records of a table without using
COUNT function?
Answer Posted / l meher
select max(rownum) from table_name;
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
Can we commit inside a trigger?
Why are aggregate functions called so?
how to see the create table statement of an existing table? : Sql dba
What is percent sign in sql?
what are null values? : Sql dba
How do you sort in sql?
What does inner join mean?
What are the different types of functions in sql?
How to run sql functions in pl/sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What are different types of keys?
Can we use commit inside a trigger?
Differentiate between pl/sql and sql?
what are the performance and scalability characteristics of mysql? : Sql dba
What is program debugging?