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
51840 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 is attribute indicator in pl sql?

1015

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1190

Does pdo prevent sql injection?

933

What is the difference between local variables and global variables?

1125

What are the two characteristics of a primary key?

982

Is truncate ddl or dml?

991

what is the command used to fetch first 5 characters of the string? : Sql dba

1638

What is rank () in sql?

942

Mention what pl/sql package consists of?

998

what are the features and advantages of object-oriented programming? : Sql dba

1011

What is pl sql code?

1056

Where can I learn sql for free?

988

What are the different types of dbms?

1016

What is the left table in sql?

963

How many sql databases can you have on one server?

1083