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 happens if null values are involved in expressions? : Sql dba

999

---

Can I call a procedure inside a function?

944

---

What are synonyms in sql?

928

---

How to select random rows from a table?

1018

---

Which join condition can be specified using on clause?

898

---

What is meant by temporal data?

903

---

How do you get column names only for a table (sql server)?

1099

---

What does pragma mean?

970

---

Explain raise_application_error.

1041

---

What are the ways on commenting in a pl/sql code?

1049

---

Which one is faster ienumerable or iqueryable?

864

---

What operating systems are supported by oracle sql developer?

902

---

What is loop in pl sql?

978

---

Explain what is a view?

995

---

What's the difference between inner join and left join?

946

---