Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 29 Answers
- 51697 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / "d"
select count(*),ss from dd group by
ss having count(*)>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is difference between hql and native sql?
Is postgresql a nosql database?
What is the difference between inner join and left join?
Can a view be mutating? If yes, then how?
what is commit? : Sql dba
Which command is used to delete a package?
Why do we use function in pl sql?
Explain the types of joins in sql?
What is the difference between database trigger and stored procedure?
Why we use sql profiler?
What do you understand by pl/sql records?
What is sql*loader and what is it used for? : aql loader
What is the use of sqldataadapter?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
