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
Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined):       Ans:  The relational database schema f


Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized.

What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.


What do you understand by RAID? Explain RAID Level 4 and Level5? RAID - It is stands for Redundant Array of Inexpensive Disks (as named by the inventor), or alternatively Re

1. Staff (staffID --> availabilityID) 2. Services (servicesID --> itemBasedID --> timedBasedID) 3. TimedBased (timedbasedID--> priceid) 4. Clients (clientId, serviceId-->

The users who use easy-to-use menu are called ? The users who use easy to use menu are called as Naïve users.

Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri

The Update Operations : Update operations are used for altering database values. The constraint violations faced by this operation are logically the similar as the problem faced