What does “select count(1) from tab” result?
Answer Posted / prerna
If tab is table name then it gives total no of rows present
in that table.
Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What does rownum mean in sql?
what is self join and what is the requirement of self join? : Sql dba
what are rollup and cube in t-sql? : Transact sql
Does sql profiler affect performance?
Write the command to remove all players named sachin from the players table.
What is the difference between delete and truncate commands?
What is java sql connection?
What does fetching a cursor do?
Can you select everything, but 1 or 2 fields, without writer's cramp?
How do I partition a table in sql?
What is group by in sql?
What is rownum in sql?
What is a relationship and what are they?
Does view contain data?
what is text? : Sql dba