Answer Posted / shalu

select count(*) from table_name group by column1,column2...
having count(*) > 1

Can we call procedure in select statement?

970

---

Can we commit in trigger?

920

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1537

---

What is database white box testing and black box testing?

1045

---

Is sql free?

884

---

What do we need to check in database testing?

963

---

Can we use view in stored procedure?

862

---

What is a procedure in pl sql?

1123

---

What are pl/sql packages?

1035

---

how is myisam table stored? : Sql dba

995

---

What does an inner join do?

1089

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

981

---

Can we use commit inside a trigger?

1023

---

How can get second highest salary in sql?

907

---

Is sql an operating system?

956

---