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

How do I run a program in pl sql?

1053

what is cross join? : Sql dba

1046

When can we use the where clause and the having clause?

1076

How to load data with sql*loader?

1110

what is the difference between where clause and having clause? : Sql dba

1042

What are the ddl commands?

1052

What are sql injection vulnerabilities?

1024

What is a delimiter in sas?

1124

What are the most important characteristics of pl/sql?

1224

What is sap sql anywhere?

1162

Explain the working of foreign key?

1135

What is the use of function in sql?

1147

How many aggregate functions are available there in sql?

1018

how to use like conditions? : Sql dba

1162

What is a constraint? Tell me about its various levels.

1244