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

Answer Posted / guest

it results out the count of record in the table result

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

543


what is primary key? : Sql dba

512


Is delete faster than truncate?

547


Is sql port 1433 encrypted?

576


define join and explain different type of joins? : Sql dba

546






What is a loop in sql?

569


How to sort the rows in sql.

603


Can we rename a column in the output of sql query?

543


what is a database lock ? : Sql dba

594


How many triggers can be applied to a table?

600


Can dml statements be used in pl/sql?

579


What is trigger with example?

565


What is the difference between delete and truncate statement in sql?

497


Describe different types of general function used in sql?

532


What is an ndf file?

534