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
the of super market system done in database

Can we delete data element, which is being used by table fields. No we cant delete data element.


Explain the functions of data manager? Functions of Data Manager : - Convert operations in user's queries coming directly through query processor or indirectly in an applicatio

Though all the ABAP/4 Dictionary Structures that exists in the structure of the LDB, being described in Database Program, we are explaining the Dictionary Structures in the Report.

What Command You Use What Day of the week were you born

Every simple attribute of an entity type have a possible set of values that can be attached to it. This is known as the domain of an attribute. An attribute cannot have a value out

#questiononsider the following relation: CAR_SALE =(CAR_ID,oPTION_TYPE, Option_listpreice, Sale_date, Option_discountedprice)..

er diagram on cosmetics.

What do you understand by transitive dependencies? Define with an example any two problems that can take place in the database if transitive dependencies are available in the datab