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
- 18790 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 is indexing done in search engines?
Define commit, rollback and savepoint?
What are synonyms in sql?
What is mutating trigger?
Explain aggregate functions are available there in sql?
What is a join query?
What is use of package in pl sql?
how to get second highest salary in SQL(as/4000
Explain the steps needed to create the scheduled job?
What is pl sql block structure?
What is the use of function "module procedure" in pl/sql?
what is 'mysqldump'? : Sql dba
-
Oracle (3259) - 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)
