select* from tab; gives you the o/p as a table containing rows and columns.

What does “select count(1) from tab” result?

Question Posted / rutujagabhane

10 Answers
21120 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / 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;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why is pl sql used?

984

Explain dml and ddl?

996

What is a temporal data type?

1052

What are the different sql languages?

1036

What is trigger explain it?

1017

Is left join and outer join same?

1070

how is exception handling handled in mysql? : Sql dba

1083

What is microsoft t sql?

949

What are the benefits of stored procedures?

1074

Explain clause in sql?

1032

How is a process of pl/sql compiled?

1160

What is normalization? How many normalization forms are there?

1086

What is varchar sql?

1146

How do I add a database to sql?

1126

What is server name sql?

1148