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 sql indexes?

934

What is audit logout in sql profiler?

977

What is difference between table and view?

974

what are the authentication modes in sql server? How can it be changed? : Sql dba

1320

Define sql delete statement.

953

What are pl/sql packages?

1035

Is sql better than access?

961

What are all different types of collation sensitivity?

973

How do you change a value in sql?

965

Can we use loop in sql?

922

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1133

How to pipe multiline string to isql?

959

What mean sql?

950

What is transaction control language (tcl)?

1069

What is the purpose of using pl/sql?

1075