Interested to Buy Any Domain ? << Click Here >> for more details...
what eliminate duplicate without using roenum and not
- 5 Answers
- 10465 Views
- Matrix, I also Faced
- E-Mail Answers
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
How do I write a cron which will run a sql query and mail the results to agroup?
How do you update a table in sql?
what are the different index configurations a table can have? : Sql dba
Explain the advantages and disadvantages of stored procedure?
What is sap sql anywhere?
What is sql query limit?
What are character functions in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
What is raw datatype in sql?
How do you write an index?
How do I edit a stored procedure?
Does sql full backup truncate logs?
What are the various restrictions imposed on view in terms of dml?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What are the different ways to optimize a sql query?
