Answer / gourvendra singh

select count(1) from tab will give the total number of
tables,views and synonms present in the current schema.

Answer / vishnu

SELECT COUNT(1) FROM TAB

ANS:It gives the total number of tables,views,synonyms
present in that schema.

Answer / prerna

If tab is table name then it gives total no of rows present
in that table.

Answer / sunil

Tab is system view which will provide you the list of
table,view,cluster,synonym in the current schema .

Answer / guest

it results out the count of record in the table result

Answer / rutujagabhane

select* from tab; gives you the o/p as a table containing rows and columns. The rows contain the name of table ,select count(1) from tab returns the no or rows in tab .
Indirectly the statement returns no of tables in tab;

Answer / phani

It returns the count of all tables for that user.

Answer / indrajeet kumar

SELECT COUNT(1) FROM TAB

RESULT IS 91

Answer / ali

A column function does not use any column name.

Answer / mahi

It will give the latest row of the table.

how do you know the version of your mysql server? : Sql dba

0 Answers  

What is a primary key example?

0 Answers  

Can we insert data into view?

0 Answers  

Where the Pre_defined_exceptions are stored ?

2 Answers  

What is query syntax?

0 Answers  

What are hotfixes and patches?

0 Answers  

What is the difference between SQL and PLSQL

7 Answers   IBM,

What view means?

0 Answers  

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

What is the difference between sql and isql*plus?

0 Answers  

How can I change database name in sql?

0 Answers