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
51670 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

How to make a copy values from one column to another in sql?

1028

How to display the current date in sql?

1067

how many columns can be used for creating index? : Sql dba

938

How do you modify a trigger?

919

Does google use sql?

950

what are the authentication modes in sql server? : Sql dba

1056

What is the difference between instead of trigger and after trigger?

997

Explain raise_application_error.

1084

what is 'mysqld'? : Sql dba

963

What is rowid in sql?

974

What is trigger and stored procedure in sql?

1023

What is asqueryable?

960

How many types of triggers are there in pl sql?

1060

Inline the values in PL/SQL, what does it mean.?

1211

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1015