Answer / satheesh

SELECT * FROM EDUCATION E1 WHERE ROWID>(SELECT MIN(ROWID)
FROM EDUCATION E2 WHERE E1.EMPID=E2.EMPID)

Answer / sirisha

select id,count(id) from Education group by id having count(id)>1

Answer / aditi yadav

SELECT *FROM Employee
WHERE JoiningDate >= DATEADD(M, -2, GETDATE())

Answer / keerthana

select Student_Name,Dgree from Education
group by (Student_Name,Dgree) having count(*) > 1;

Answer / karthik

i think ths will work!
select * from table_name where rowid in (select max
(rowid) from table_name groupby duplicate_field_name);

Answer / lavanya

SELECT COUNT(*), <COLUMN_NAME> FROM EDUCATION GROUP BY
<COLUMN_NAME>

Answer / guest

unionall

Answer / dawood

SELECT COUNT(EMPNO),ENAME FROM EDUCTION
GROUP BY ENAME;

Answer / harish

select * from education where rownum < ( select max(rownum)
from education group by <column_name> )

What are sql*plus environment variables?

0 Answers  

What is clause?

0 Answers  

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

What is benefit of creating memory optimized table?

0 Answers  

How to display all Friday's in a year with date?

4 Answers   Flipkart,

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

Explain mutating table error.

0 Answers  

In what condition is it good to disable a trigger?

0 Answers  

what are the nonstandard string types? : Sql dba

0 Answers  

what is bcp? When is it used?

0 Answers  

What are the different types of joins and explain them briefly.

3 Answers  

is it possible to pass an object or table to a procedure as an argument?

0 Answers