To eliminate duplicate rows-data manipulation language, Database Management System

To eliminate duplicate rows (distinct operator)

 Example:

SELECT DISTINCT DEPTNO FROM EMP;

 

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







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
Related Questions
Data Scrubbing 70,000 records Project Description: We need services of a developer competent in data cleansing/Data scrubbing. Scope: - 70,000 records in CSV format.

what is meant semantic query optimization? how does it differ from other query optimization techniques?

How much would you charge to create a database encompassing an Online Bakery with all the elements below? I. Describe the application that you would like to design. This should

Describe file organisation? A file is organized logically as a sequence of records. These records are mapped onto disk blocks. A) Fixed-Length Records Type deposit=record

Consider the following relational database: STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course#, sem

ERD Diagram of Medical Recruitment Agency?

Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)

what is database management system? & why it is required?

What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

1. A company wants a report containing a breakdown of payroll by department. Input, which should be stored in 3 parallel arrays, includes each employee's department number, hourly