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
50654 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 AUTH_ID and AUTH_USER in pl/sql ?

2134

What is the primary key?

876

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1111

What is cursor in pl sql?

1049

tell us something about heap tables. : Sql dba

1047

What is schema in sql?

880

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

1584

Can we group by two columns in sql?

940

What is the purpose of a sql?

909

Explain dml and ddl?

919

What are the different sql commands?

1000

how to create a test table in your mysql server? : Sql dba

941

What do you mean by rowid?

911

What are the commands used in sql?

1006

How to run pl/sql statements in sql*plus?

1017