select max(rownum) from table

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

Question Posted / ramaraju

Answer Posted / ramaraju

select max(rownum) from table_name;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are inner outer left and right joins in sql?

1006

Define the select into statement.

1045

Can you select everything, but 1 or 2 fields, without writer's cramp?

977

What are its different types of dbms?

997

How can get second highest salary in sql?

978

What is sqlerrm?

927

what is the functionality of the function htmlentities? : Sql dba

945

What is crud diagram?

936

Can we use commit inside a trigger?

1080

how to present a past time in hours, minutes and seconds? : Sql dba

1004

How do you go back in sql?

983

What is meant by cursor in sql?

982

what is a database? : Sql dba

1159

how many triggers are allowed in mysql table? : Sql dba

1057

Is sql considered coding?

1040