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.

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  

Can I join the same table twice?

0 Answers  

What is nvarchar max in sql?

0 Answers  

What is bulk collect in pl sql?

0 Answers  

What has stored procedures in sql?

0 Answers  

Are sql views compiled?

1 Answers  

What is an emotional trigger?

0 Answers  

What is the use of partition by in sql?

0 Answers  

What are wait events. Describe the wait event tables.

1 Answers   CTS,

What are the events on which a database trigger can be based?

0 Answers  

Is a table valued function object?

0 Answers  

describe mysql connection using mysql binary. : Sql dba

0 Answers