what eliminate duplicate without using roenum and not
Answer Posted / satyajit patel
Mr. Kondla is almost right, but forgotten to use keyword
DISTINCT. It should be like
-> create table T2 as select DISTINT(*) from T1;
-> drop table T1;
-> rename T2 to T1;
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is compiled query?
Is pl sql different from sql?
How do I run a sql query in pgadmin 4?
Can a foreign key have a different name?
what is 'mysqld'? : Sql dba
What are all ddl commands?
What is multiple partition?
How can I see all tables in sql?
Why procedure is used in sql?
What is a trigger word?
Can we use threading in pl/sql?
Can we perform dml on view?
How do you go back in sql?
What is prepared statement in sql?
How do you use collections in procedure to return the resultset?