'a query by which we can get only the duplicate values from the TABLE OF A DATABASE
What table structure? PK if any? Details would be needed. Further, just Google it and you will get for most of standard condition.
Well, let me Google that for you, here