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
- 19619 Views
- UST, I also Faced
- E-Mail Answers
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 do I run a sql trace?
Is sql scripting language?
What is the benefit of foreign key?
if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Is sql similar to python?
What are actual parameters and formal parameters?
When are we going to use truncate and delete?
how to include character strings in sql statements? : Sql dba
What is dynamic SQl and how you will create and execute dynamic sql?
What is union and union all keyword in sql and what are their differences?
How do you write a subquery?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
