select max(rownum) from table-name; Here rownum is a keyword which can g

With out using count() function. How to the find total
number of rows in a table?

Question Posted / subbarayulu neela

Answer Posted / subbarayulu neela

select max(rownum) from table-name;

Here rownum is a keyword which can gives unique number for
individual rows.

Is This Answer Correct ?

35 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Write a sql query to convert all character to uppercase after hypen.

1169

how to delete an existing column in a table? : Sql dba

716

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2189

How does cross join work in sql?

706

what is the bond code in materialized view?

2683

Write a unique difference between a function and a stored procedure.

714

What is a string data type in sql?

718

What is set serveroutput on in pl sql?

814

What is cartesian join in sql?

744

What is numeric function sql?

724

what is msql? : Sql dba

753

What are the two characteristics of a primary key?

669

How does sql developer connect to oracle database?

742

How do you write a complex sql query?

779

How do I enable sql encryption?

715