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)

How is data stored in dbms?

0 Answers  

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  

---

Explain the role of indexing in databases?

0 Answers  

---

how to find the first two highest salaries in deptno in emp table

2 Answers  

---

Can you have a nested transaction?

1 Answers  

---

How to create an external table.

1 Answers  

---

Can you instantiate a COM object by using T-SQL?

1 Answers  

---

How can you fix a poorly performing query?

0 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

what is the use of foreginkey

2 Answers  

---

can you give me the syntax of named procedure??

2 Answers  

---

agregator gives one to many records or many to one record

1 Answers   IBM,

---