Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 19264 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / kishor solanki @ 9904762204
create table newtable as select * from oldtable order by dupcol;
drop oldtable;
rename newtable to oldtable;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many indexes can be created on a table in sql?
What is compilation error in pl sql?
What is the purpose of normalization?
What are the possible values that can be stored in a boolean data field?
What are the two types of cursors in pl sql?
How do I count rows in sql query?
What is bitemporal narrowing?
When to use inner join and left join?
What does an inner join do?
how to use case expression? : Sql dba
How can check sql version from command line?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What is pl sql script?
explain the advantages and disadvantages of stored procedure? : Sql dba
where are cookies actually stored on the hard disk? : Sql dba
