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

What is rank function in sql?

724


what does the t-sql command ident_incr does? : Transact sql

805


what are numeric data types? : Sql dba

761


Does pl/sql support create command?

743


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

850






How do I find sql profiler?

683


What is the basic structure of an sql?

758


What is oracle sql called?

675


how to get @@error and @@rowcount at the same time? : Sql dba

741


What is the difference between a subquery and a join?

702


How many unique keys can a table have?

740


Is sqlite good enough for production?

734


Is t sql a programming language?

761


how to fetch common records from two tables? : Sql dba

842


What is the current version of postgresql?

734