Answer Posted / dev

Hi,
There are many ways to do it.

One of that is ,

select count(0) from tab1 a
where a.rowid > any (select b.rowid from tab1 b where
a.col1 =b.col1);

how can we know the number of days between two given dates using mysql? : Sql dba

1053

---

Is pl sql still used?

984

---

How many types of relationship are there?

1040

---

How do I edit a trigger in sql developer?

1006

---

what are different types of collation sensitivity? : Sql dba

1080

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1236

---

List and explain the different types of join clauses supported in ansi-standard sql?

1360

---

how to drop an existing table in mysql? : Sql dba

1057

---

What operating systems are supported by oracle sql developer?

975

---

What is difference between my sql and sql?

1084

---

Is sql a dbms?

1024

---

Can we use commit inside a trigger?

1103

---

What is column?

1001

---

What is pls integer?

1054

---

Can %notfound return null after a fetch?

1071

---