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;

What is meaning of <> in sql?

1056

---

Can you skip header records while loading? : aql loader

1019

---

What are the advantages of indexing?

967

---

What is exit statement?

1000

---

Is ms sql traffic encrypted?

909

---

What are the types of functions in sql?

997

---

What is pivot in sql?

902

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1041

---

What does joining a thread mean?

1003

---

What are three advantages to using sql?

993

---

how to convert character strings to numeric values? : Sql dba

1079

---

what are the types of subquery? : Sql dba

1087

---

Explain lock escalation? : Transact sql

1174

---

how to create a test table in your mysql server? : Sql dba

990

---

What is the primary key?

934

---