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

how to rename an existing column in a table? : Sql dba

504

How many sql commands are there?

662

Could you please provide oca (oracle 10g) dumps for my certification ?

4502

How many disk partitions should I have?

543

Explain correlated query work?

583

What is foreign key sql?

546

what is isam? : Sql dba

566

Is sql pronounced sequel or sql?

730

What is rowid in sql?

501

what does the t-sql command ident_current does? : Transact sql

535

What is the difference between between and in condition operators?

528

Is natural join and inner join same?

485

how to convert dates to character strings? : Sql dba

531

What is the maximum rows in csv?

481

Can we join same table in sql?

518