What does “select count(1) from tab” result?

Answer Posted / phani

It returns the count of all tables for that user.

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

define sql update statement ? : Sql dba

807


What is rownum?

711


What is bulk collect in pl sql?

729


Is sql difficult?

924


what is row? : Sql dba

935






name 3 ways to get an accurate count of the number of records in a table? : Sql dba

790


How to pronounce postgresql?

769


Are stored procedures faster than queries?

698


Explain the working of primary key?

839


what is isam? : Sql dba

768


What are the different types of functions in sql?

759


What is a constraint? Tell me about its various levels.

839


How to start oracle sql developer?

753


What do you understand by pl/sql records?

721


Can unique keys be null?

663