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 are the different types of dbmss?

1015

How does left join work in sql?

1001

what are rollup and cube in t-sql? : Transact sql

1096

What are the two characteristics of a primary key?

975

Can you select everything, but 1 or 2 fields, without writer's cramp?

984

What is the difference between Union and Union all. Which is faster.

1402

How do I run a query in pl sql developer?

994

How do I add a database to sql?

1125

What are the two virtual tables available at the time of database trigger execution?

1222

How does a covering index work?

960

How do you select unique values in sql?

997

Explain table and field in sql?

1062

What is difference between sql function and stored procedure?

1003

What is composite primary key in sql?

996

How do you exit in sql?

1108