With out using count() function. How to the find total
number of rows in a table?
Answer Posted / ramaraju
select max(rownum) from table_name;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you add a column to a table?
Is it possible to create startup or shutdown trigger for on-schema?
What is clustered index sql?
What types of commands can be executed in sql*plus?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
what is sql server agent? : Sql dba
What do you mean by stored procedures?
Explain polymorphism in pl/sql.
what is the difference between $message and $$message? : Sql dba
What is the main reason behind using an index?
Why select is used in sql?
describe transaction-safe table types in mysql : sql dba
Why are aggregate functions called so?
Is the primary key an index?
How does cross join work in sql?