To eliminate duplicate rows (distinct operator)

 Example:

SELECT DISTINCT DEPTNO FROM EMP;

 

Posted Date: 3/11/2013 1:03:18 AM | Location : United States

Ask an Expert

Related Discussions:- To eliminate duplicate rows-data manipulation language, Assignment Help, Ask Question on To eliminate duplicate rows-data manipulation language, Get Answer, Expert's Help, To eliminate duplicate rows-data manipulation language Discussions

Write discussion on To eliminate duplicate rows-data manipulation language
Your posts are moderated

Write your message here..

Related Questions

Define direct file organization, Define Direct file organization? The d... Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file

Special comparison operator used in where clause-dml, Special comparison op... Special comparison operator used in where Clause a.   between. ...and...It gives range among two values (inclusive) Example: SELECT ENAME, SAL FROM EMP WHERE SAL BETWE

State the object design for processing, State the Object Design for Process... State the Object Design for Processing  The object design phase comes after analysis and system design phase. The object design phase includes implementation details like as i

Dbms, You are managing the following database system: • DBMS: Oracle 11g ... You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR managem

Describe second normal and third normal form, Database Management Systems ... Database Management Systems 1. Explain SQL Server 2000 Architecture with diagram. 2. Describe Second Normal and Third Normal Form. 3. Explain about query engine and stora

A distributed transaction, A Distributed Transaction Let us demonstrate... A Distributed Transaction Let us demonstrate the concept of a distributed transaction by considering a banking system having of three branches located in 3 different cities. Ev

In which format database schema is written, In which format database schema... In which format database schema is written ? Data base schema is written in the DDL format.

Data analyzing and desing, Critically explained the benefits and limit... Critically explained the benefits and limitations of different database technologies with proper examples

School portal design and development, Project Description: This is going... Project Description: This is going to be a School portal to handle each activities in school such as, School fees payment, online registration and every other payment, course re

Creation of indexes, Creation of Indexes Automatically: When a primar... Creation of Indexes Automatically: When a primary key or Unique constraint is show in a table definition then a unique index is formed automatically. Manually: User can