How to delete the duplicate colums in a sql table ?
Answer Posted / 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 |
Post New Answer View All Answers
can anybody tell me about complicated object you have created
What Is Snow Flake Schema?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What is a fantrap in business objects?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is object stores?
What is the dense rank?
What is difference between custom hierarchy and report based hierarchy?
Give some information on report bursting?
What we need to discuss with designer before starting the universe designing.
any difficulitis have you phase while creating bo reports and how did u solve it
How can you first report in Business Objects by using broadcast agent?
What is the difference between the public object&schema object?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?