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

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

595


What is sql trigger example?

541


Name some usages of database trigger?

564


What is the use of sqlerrd 3?

521


Write the alter statement to enable all the triggers on the t.students table.

673






What is procedure and function?

520


What is the use of nvl function?

619


What is the max nvarchar size?

518


Enlist some predefined exceptions?

583


Does sql require a server?

532


Can a table have no primary key?

555


What is scalar function?

569


Explain scalar functions in sql?

581


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

511


What is your daily office routine?

1810