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

What is the file extension for sql database?

519


What is meaning of <> in sql?

588


Which kind of parameters cannot have a default value in pl sql?

598


Can we call a function containing dml statements in a select query?

547


Why query optimization is needed?

521






What is database sql?

543


What are the basic sql commands?

550


what is sql in mysql? : Sql dba

571


What is bitemporal narrowing?

739


What is a schema? How is it useful in sql servers?

595


Explain some predefined exceptions.

589


How can I tell if sql is running?

591


Determine if oracle date is on a weekend?

558


What is a file delimiter?

558


what are all the different types of indexes? : Sql dba

534