select sum(1) from table-name

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

Question Posted / saurabh

Answer Posted / saurabh

Is This Answer Correct ?

26 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Which one is better sql or oracle?

914

difference between anonymous blocks and sub-programs.

1084

Mention what is the function that is used to transfer a pl/sql table log to a database table?

943

What is an index in sql with example?

925

What is view? Can we update view

1367

How do you rename a table in sql?

1045

What is the use of count (*) in sql?

994

What are the set operators in sql?

1037

How do you copy a table in sql?

1022

What is sql used for?

1073

What are procedures used for?

931

Is sql sequential or random?

990

What is implicit cursor in pl sql?

1037

Is join same as left join?

983

Is it important to partition hard disk?

974