Answer Posted / ajmal khan

There are many way to count the duplicate row in a table
select count(column_name)-count(distinct(column_name)) from
table_name;

What are the differences between in and exists clause?

573

---

What is string join?

559

---

Which is better join or inner query?

522

---

How to return multiple rows from the stored procedure?

526

---

Explain polymorphism in pl/sql.

641

---

---

What is relationship? How many types of relationship are there?

594

---

What is range partitioning?

522

---

describe mysql connection using mysql binary. : Sql dba

555

---

Is mariadb nosql?

588

---

Sql technical questions

779

---

What is index example?

562

---

what is commit? : Sql dba

619

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

565

---

What is type and rowtype in pl sql?

541

---

How do you declare a variable in pl sql?

537

---