Answer Posted / prakash kumar
select max(rownum)from table_name;
this will also give number of rows in your table
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
what is 'mysqlshow'? : Sql dba
Can we insert in sql function?
Differentiate between % rowtype and type record.
What is number function in sql?
What is the difference between execution of triggers and stored procedures?
how to write date and time literals? : Sql dba
Why truncate is used in sql?
Which are the different character-manipulation functions in sql?
If a cursor is open, how can we find in a pl/sql block?
What is the function that is used to transfer a pl/sql table log to a database table?
How can we implement rollback or commit statement in a trigger?
what is a trigger? : Sql dba
What are different clauses used in sql?
What does pl sql developer do?