Answer Posted / rashmi

select max(rownum) from table1 where rowid is not null

How many row comparison operators are used while working with a subquery?

542

---

How do I count rows in sql?

561

---

Why do we use joins?

570

---

What is restrict in sql?

561

---

What is rename command in sql?

470

---

---

How do you update sql?

523

---

Is sql pronounced sequel or sql?

749

---

Why self join is used in sql?

499

---

how to dump a table to a file with 'mysqldump'? : Sql dba

555

---

What is keys and its types?

547

---

Is time a data type in sql?

486

---

What is record type in pl sql?

552

---

How many types of primary keys are there?

533

---

what is top in tsql? : Transact sql

549

---

how to get @@error and @@rowcount at the same time? : Sql dba

532

---