how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
Answers were Sorted based on User's Feedback
If you wish to remove duplicate values, then use the
DISTINCT parameter.
Consider there is a table:emp, with deptno. as one of its
coloumn. This coloumn has repeated values. Then you should
use the following query to remove the duplicate values:
SELECT DISTINCT deptno FROM emp;
Is This Answer Correct ? | 2 Yes | 3 No |
how to get second highest salary in SQL(as/4000
Is sql pronounced sequel or sql?
What is Difference Between delete and Truncate?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
write a query to delete similar records in same table
What is Highwatermark?
Describe the Index, Types of index, At what situation we have used? Which one s better than others?
Is left join faster than inner join?
what are the forced views
How do I run pl sql in sql developer?
Does truncate remove indexes?
how are rank and dense rank being alloted for column with same values over a particular column