What does “select count(*) from tab” result?
Answers were Sorted based on User's Feedback
Answer / rahul koshti
This results the total count of tables,views,synonyms and
sequences present in a schema.
Is This Answer Correct ? | 19 Yes | 3 No |
Answer / ashwin
No of tables and views in schema...........i've tasted
it........
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / deepshikha
it will result the count of TABLE,CLUSTER,VIEW,SYNONYM
in given schema
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / nisha
This results the total count of tables,views,synonyms
present in a schema.
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / umesh h
suppose a table is there with the name tab
then count of rows in that table will be displayed.
else count of all the logical objects under one schema
will be displayed.
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / shanmukha srinivas
select count(*) from tab --it's gives total no of tables only ....not gives
sequence,cluster,views....etc
ok understand.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / brajesh kr.
select count(1) from table. will return values without null
values. count(*) will return values aceept null also.
Is This Answer Correct ? | 0 Yes | 2 No |
How do I view a sql database?
Is sql a oracle?
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
what is sql server agent? : Sql dba
What is sqlite format?
What is sqlerrd?
explain the difference between myisam static and myisam dynamic. : Sql dba
What are the set operators in sql?
what is data integrity? : Sql dba
what are the differences between binary and varbinary? : Sql dba
what is the difference between where clause and having clause? : Sql dba
What is oracle and pl sql?