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
- 17492 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / lakshya
SELECT * FROM table_name
WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM table_name GROUP
BY table_columns);
| Is This Answer Correct ? | 9 Yes | 8 No |
Post New Answer View All Answers
how many ways to get the current time? : Sql dba
What do you mean by “trigger” in sql?
How would you pass hints to the sql processor?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Can you join a table to itself?
What is dense_rank in sql?
How to use boolean type in select statement?
What is coalesce in sql?
What is the purpose of the sql select top clause?
How to disable a trigger name update_salary?
what are integrity rules?
Does sql*plus also have a pl/sql engine?
Define implicit and explicit cursors.
what is collation? : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
