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);

what is a trigger? : Sql dba

1016

---

How many indexes can be created on a table in sql?

1037

---

What is difference between ms sql and mysql?

948

---

What is group function in sql?

1002

---

What is rename in sql?

958

---

Write the command to remove all players named sachin from the players table.

1169

---

Does sql require a server?

994

---

What is embedded sql in db2?

999

---

What is string data type in sql?

1120

---

what is the difference between char_length and length? : Sql dba

1028

---

What does where 1 1 mean in sql?

1022

---

How do I count duplicates in sql?

1086

---

What are the various levels of constraints?

1117

---

What is sql not null constraint?

1012

---

What is a scalar value in sql?

1059

---