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

What are inbuilt functions in sql?

595


How many parts of a pl sql block are optional?

515


What is a trigger in sql?

634


What are the various restrictions imposed on view in terms of dml?

518


What is the difference between cross join and natural join?

564






what are the advantages of mysql in comparison to oracle? : Sql dba

525


What does 0 mean in sql?

526


What is composite primary key in sql?

520


What is sql*loader and what is it used for?

578


How can we make an if statement within a select statement?

539


Show the two pl/sql cursor exceptions.

612


What is clause in sql?

579


Describe types of sql statements?

543


Which normal form is best?

512


What is the need of merge statement?

550