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

Answer Posted / saurabh

select sum(1) from table-name

Is This Answer Correct ?    26 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why truncate is faster than delete?

788


Is it possible to read/write files to-and-from PL/SQL?

840


What is pl sql record in oracle?

756


what is bcp? When is it used?

769


Define implicit and explicit cursors.

809






What is nvarchar in sql?

714


How do you modify a trigger?

695


Can I learn sql in a week?

753


what is table? : Sql dba

763


Can we perform dml in function?

796


How do I order by ascending in sql?

741


What is meant by truncate in sql?

752


What is data definition language?

803


What are the types of queries in sql?

741


What is a sql trace file?

740