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)

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

What are the constraints on severity level in raiseerror?

0 Answers  

---

How to use timestamp datatypes

0 Answers  

---

hi in which phase of mload can i use .FILLER

1 Answers   IBM,

---

Explain about normal forms?

0 Answers  

---

---

In which database can extended stored procedures be added?

0 Answers  

---

How is data stored in dbms?

0 Answers  

---

fact table and dimension table containg one to many relationship or many to one relastionship

0 Answers  

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

0 Answers  

---

How can you fix a poorly performing query?

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 the system function to get the current user's user id?

4 Answers  

---