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

Designing the hierarchy of a ldb?, What sorts of tables one can se in desig... What sorts of tables one can se in designing the hierarchy of a LDB? Tables, which are having Foreign Key relations.

What creates while a primary key is combined with a foreign, What it create... What it creates while a primary key is combined with a foreign key? It creates Parent-Child relation ship between the tables that connect them while a primary key is combined w

What does data dictionary is a special file contains, What does data dictio... What does data dictionary is a special file contains ? The data dictionary is a special file contain The name of all fields in all files.The width of all fields in all files an

Describe how you can simplify operations, Describe how you can simplify Ope... Describe how you can simplify Operations. To simplify operation, one should use inheritance, where possible to use, to reduce the quantity of distinct operations. Introduce new

Lack of redundancy, Lack of Redundancy We have talked about the problems o... Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again t

OLAP CUBES, 1) Define a job scheduling strategy that will meet business req... 1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Accounting and external reporting, List the internal controls that should b... List the internal controls that should be in effect solely because a EDP system is employed, classifing them as (1) Those controls pertaining to input of information and (2) All ot

Variable length record, what are the reasons having variable length records... what are the reasons having variable length records

What are the various properties of relational tables, What are the various ... What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

What is primary key, What is Primary key? Primary Key - Primary key i... What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.