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

What is sql used for?

1110

What is difference between my sql and sql?

1058

How many scalar data types are supported in pl/sql?

1043

What are all the common sql functions?

1008

What is primary key sql?

1025

What does data normalization mean?

947

What is a natural join sql?

963

where are cookies actually stored on the hard disk? : Sql dba

1022

How does postgresql compare to mysql?

1029

How many aggregate functions are available there in sql?

978

Is ms sql traffic encrypted?

915

how to enter binary numbers in sql statements? : Sql dba

964

What is graph sql?

980

What is restrict in sql?

1101

Can primary key be changed?

902