select rownum from table

How to count the no of records of a table without using
COUNT function?

Question Posted / sudhakar & co

Answer Posted / sudhakar & co

select rownum from table_name;

Is This Answer Correct ?

1 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Which is faster joins or subqueries?

930

What is the execution plan in sql?

973

how to shut down the server with 'mysqladmin'? : Sql dba

955

how do you tune the slow running queries in oracle db , explain the methodology

2059

What is set serveroutput on?

1087

Is pl sql a programming language?

925

How delete a row in sql?

926

What is rank () in sql?

882

What are the types of optimization?

887

What is the maximum number of triggers, you can apply on a single table?

945

Explain clause in sql?

959

Are stored procedures faster than queries?

898

What is multiple columns?

1001

Explain the significance of the & and && operators in pl sql.

950

What are %type and %rowtype for?

1012