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)

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

---

Explain about a primary key?

0 Answers  

---

What are data modelling techniques?

0 Answers  

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

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,

---

What are the key features of dbms?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---

Explain about normal forms?

0 Answers  

---

What are the constraints on severity level in raiseerror?

0 Answers  

---