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

Answer Posted / indrajeet kumar

SELECT COUNT(1) FROM TAB

RESULT IS 91

Is This Answer Correct ?    2 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why stored procedures are faster than query?

570


What is set serveroutput on?

642


What is the use of primary key?

537


Can we use pl sql in mysql?

519


What is rank function in sql?

534






What are the types pl/sql code blocks?

609


What are the dml statements?

689


What steps server process has to take to execute an update statement?

511


How do you create an update query?

524


What is t sql in sql server?

571


Is postgresql a nosql database?

535


what are the different type of normalization? : Sql dba

555


How do I save the results of sql query in a file?

535


Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

537


How do you declare a user-defined exception?

530