Answer Posted / ravi patel

for the table emp
ID NAME
1 ravi
2 umang
1 ravi
3 nishant

now fire the query as beleow

select * from emp group by id,name having count(id)>1 and
count(name)>1;

how to calculate expressions with sql statements? : Sql dba

985

---

What are the ddl commands?

951

---

How do you explain an index number?

1023

---

How does index help in query performance?

968

---

Which one is better subquery or joins?

1010

---

What is restrict in sql?

1035

---

What is the difference between nested table and varray?

944

---

What is sql profiler in oracle?

1015

---

What is the cause of mutating table error and how can we solve it?

995

---

How do I upgrade sql?

949

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

895

---

What are the types of variables use in pl sql?

972

---

Is sql scripting language?

975

---

Is id a reserved word in sql?

1093

---

Why is the cursor important?

979

---