How to delete the duplicate colums in a sql table ?
- 3 Answers
- 7273 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / san
It's not at all possible to create duplicate columns in a
SQL table. The how can we delete the duplicate columns?
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / sathyasheelanbe
delete from tablename where rowid not in(select max(rowid)
from tablename group by primary key columnname)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / subash
In this query the values will delete based on employee names
delete from emp a1 where rowid<(select max(rowid)from emp a2
where a1.ename = a2.ename group by a2.ename having count(1) >1);
| Is This Answer Correct ? | 3 Yes | 4 No |
What is the difference between slice and dice and cross tab report?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How to restrict password to a user while sending a document in .pdf format
What is thin client And thick client..?
IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?
There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance
what are they different types of report in BO?
Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Is it possible to generate reports without having knowledge of the Universe structure?
How to change the order of prompts in universe?
how did u give developed universe to ur client?
Teradata 
