select max(rownum) from table

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

Question Posted / kart

Answer Posted / kart

Is This Answer Correct ?

65 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Is truncate ddl or dml?

985

What is union and union all keyword in sql?

1026

What is the difference between count 1 and count (*) in a sql query?

980

How do I start sql from command line?

1015

how to enter numeric values as hex numbers? : Sql dba

1057

What are properties of the transaction?

996

What is sql not null constraint?

1021

explain the difference between delete , truncate and drop commands? : Sql dba

1079

Mention what plvcmt and plvrb does in pl/sql?

1129

Why do we need sharding?

982

Is merge a dml statement?

971

Can we use having without group by in sql?

978

How do I count records in sql?

987

What are the two different parts of the pl/sql packages?

1075

What is normalisation and its types?

995