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

How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?

Question Posted / aditi yadav

29 Answers
52628 Views
Alps, Aricent, Bank Of America, Wipro, I also Faced
E-Mail Answers

Answer Posted / aditi yadav

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are all types of user defined functions?

1137

What is java sql drivermanager?

1161

what are all the different normalizations? : Sql dba

1120

What is the purpose of the primary key?

1117

how to extract a unit value from a date and time? : Sql dba

1040

What is offset and limit in sql?

1105

What is duration in sql profiler trace?

1140

What are stuff and replace function?

1141

What are the two different parts of the pl/sql packages?

1140

What are analytical functions in sql?

1079

What is cursor explain with example?

1031

Is sql low level language?

1066

what are different types of collation sensitivity? : Sql dba

1118

Can we join two tables without common column?

1060

Can we group by two columns in sql?

1046