Answer / manoj

select employee_id, count(*) from employees group by
employee_id having count(*) > 1

Answer / avik ganguly

select * from emp a where rowid = (select max(rowid) from
emp where empno = a.empno group by empno having count(*) >1)

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers  

---

Explain about the storage and physical database design?

0 Answers  

---

What is the physical representation for a many-to-many relationship?

0 Answers  

---

Explain about relational operator join?

0 Answers  

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

0 Answers   TCS,

---

Explain what a database is?

0 Answers  

---

Why does this query return 0?

0 Answers  

---

How can I detect whether a given connection is blocked?

0 Answers  

---

What is dbms explain in brief?

0 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

What is a self join? Explain it with an example?

16 Answers   TCS,

---

State the acid rules?

0 Answers  

---