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

Describe physical data independence, Describe Physical Data independence ? ... Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter

What is a view, What is a view?  Make a view of EMP table named DEPT 20, to... What is a view?  Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.  Ans:  View is a virtual table that does not consist

Objectives-the structured query language, Objectives After reading this... Objectives After reading this part, you should be able to: Modify, create, and delete database schema objects; Update database using SQL command; Retrieve data f

Define the phases of two phase locking protocol, Define the phases of two p... Define the phases of two phase locking protocol Growing phase: a transaction may get locks but not release any lock. Shrinking phase: a transaction might be release locks bu

The natural join is equal to which product, The natural join is equal to wh... The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

Project on designing and creating a database , This project will involve de... This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

Data control, Identify the need and use of data control through problem sol... Identify the need and use of data control through problem solving, illustration

Architectural standard, Architectural standard: Designation : Archit... Architectural standard: Designation : Architect , Consultant Job Profile : As a part of Oracle Fusion Middleware at Satyam, I am involved with Presales, Delivery, A

Attribute, composite attribute composite attribute

Describe the menu based interfaces for web clients browsing, Describe the M... Describe the Menu based interfaces for web clients or browsing? Menu-Based Interfaces for Web Clients or Browsing - These interfaces present the user along with lists of option