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
Example -Find the employee name, salary, department number and average salary of his/her department, for those employees whose salary is more than the average salary of that depart

Consider the relations given below Borrower (id_no, name) Book (accno., title, author, borrower_idno) (a) Define the above relations as tables in SQL forming real world assumptio

tell me the functionality,advantages and disadvantages of student database

What is Nested Trigger? A trigger can also having INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause ano


Need an expert in ER database theoretical and modeling database system Project Description: Need an expert in ER database theoretical and modeling database systems? Skills

What are the parts of SQL language? The SQL language has various parts: data - definitition language  Data manipulation language  View definition  Transaction contr

What are the time stamps associated with each data item? W-timestamp (Q) denotes the largest time stamp if any transaction that implemented WRITE (Q) successfully. R-timesta

Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include

Consider the entity type dependent related to employee entity, which is used to keep track of the dependents of every employee. The attributes of dependents are: name, sex, birth d