select max(rownum) from table

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

Question Posted / l meher

Answer Posted / l meher

select max(rownum) from table_name;

Is This Answer Correct ?

24 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does sign mean sql?

1036

What is indexes?

1010

What is the life of an sql statement?

980

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

902

List and explain the different types of join clauses supported in ansi-standard sql?

1314

What is the difference between having clause and where clause?

1022

What is database migration?

927

When are we going to use truncate and delete?

939

What is rank () in sql?

899

What sql does db2 use?

941

What is trigger and stored procedure in sql?

986

Does truncate release storage space?

1032

What is cold data?

910

What is composite data type in pl sql?

1048

what are all different types of collation sensitivity? : Sql dba

949