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 the left table in sql?

523

---

How many columns should be in an index?

526

---

Can we call procedure in select statement?

526

---

How do I start pl sql?

497

---

What can sql server reporting services do?

586

---

---

What are the string functions in sql?

532

---

How do I install microsoft sql?

533

---

What does select * from mean in sql?

2005

---

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

567

---

How do I run a sql query?

538

---

What are tuples in sql?

571

---

Can we use two order by clause in query?

552

---

How to disable a trigger name update_salary?

680

---

What are all the common sql functions?

571

---

Which is better join or inner query?

525

---