it will display the total number of tables in the schema.

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

Question Posted / shivashanker

Answer Posted / shivashanker

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How does join work in sql?

1052

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

1016

What are the rules to be applied to nulls whilst doing comparisons?

1367

How do you concatenate in sql?

1086

Is sql a backend language?

1144

what is offset-fetch filter in tsql? : Transact sql

998

What are functions in sql?

995

What is self-join and what is the requirement of self-join?

1191

How do rank () and dense_rank () differ?

1109

What does select top 1 do in sql?

1141

how to include numeric values in sql statements? : Sql dba

1148

What is assignment operator in pl sql?

1086

How to select all records from the table?

1181

How do you clear the screen in sql?

1122

What is crud stand for?

1048