What does “select count(1) from tab” result?
Answer Posted / vishnu
SELECT COUNT(1) FROM TAB
ANS:It gives the total number of tables,views,synonyms
present in that schema.
Is This Answer Correct ? | 23 Yes | 2 No |
Post New Answer View All Answers
How do I remove sql plus from windows 10?
How does sql profiler work?
Why is sql important?
What are database links used for?
What is a sql trace file?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is compiled query?
What does count (*) mean in sql?
What is varchar sql?
What is foreign key sql?
Why use truncate instead of delete?
What steps server process has to take to execute an update statement?
What is linq to sql?
What is sharding in sql?
How do I copy a table in sql?