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
51034 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 difference between delete and truncate commands? : Sql dba

1078

What do you understand by pl/sql records?

978

Define tables and fields in a database

1093

What does closing a cursor do?

1271

How do you remove duplicates without using distinct in sql?

938

What is the difference between joins?

990

Can you selectively load only those records that you need? : aql loader

1005

Differentiate between % rowtype and type record.

1227

Can we call stored procedure in function?

918

What is inner join in sql?

1019

Which are the different case manipulation functions in sql?

969

Is trigger a stored procedure?

903

What are the types of dbms?

937

How do I access sql anywhere database?

933

What is a procedure in pl sql?

1151