Interested to Buy Any Domain ? << Click Here >> for more details...
how to get duplicate records from tables?write qurey for this?
- 4 Answers
- 9883 Views
- ANZ, I also Faced
- E-Mail Answers
Answer Posted / pandu
To get the duplicate records in a table use the query
Select distinct(deptno) from emp;
reply any one to me am i correct.
| Is This Answer Correct ? | 2 Yes | 26 No |
Post New Answer View All Answers
How do we specify index to include or not during bind process.
What is the use of commit in db2?
What is schema in db2?
What do you mean by rollback?
What is the meaning concurrency in the db2 database?
What is difference between isnull and coalesce?
When the like statement is used?
is it compulsory commitment control in journal?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is database alias db2?
What is the use of dclgen in db2?
Is db2 a database?
What is data manager?
Outputs of explain are with matchcols = 0. What does this signify?
Which isolation level provides maximum concurrency?
