How to remove only one column values from the duplication of values in that column without using any other column references in that table?

dhanraj varshney

• Jan 6th, 2013

Two methods..
Use unique key
Run query such way-insert ignore into table.

Answer Question  Select Best Answer

Multiset table with UPI will allow duplicates or not?

Read Best Answer

Editorial / Best Answer

daniel.doboseru  

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Member Since Feb-2013 | Feb 6th, 2013

---

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it. Answer: No.

daniel.doboseru

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Feb 6th, 2013

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it.

Answer: No.

Improve Answer

How to display nth lowest record in a table for example? How to display 4th lowest (salary) record from customer table?

Read Best Answer

Editorial / Best Answer

Answered by: Yadnesh

• Jun 1st, 2013

---

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtain derived column using DENSE_RANK() in a subquery and -- obtain temporary result set and finding nth record in a temporary result set using WHERE clause -- for the given example, following is the solution.

Code
 

Yadnesh

• Jun 1st, 2013

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtai...

Improve Answer

Display 6th & 9th records only from the table using ROWNUM & MINUS & UNION ?

ramesh

• May 26th, 2016

Using Rownum we cannot display records but using set operation like minus and union then we can display the records if conditions is satisfied.

Answer Question  Select Best Answer

Why is RowSet implementation is beneficial over ResultSet?

sunil

• Mar 14th, 2016

How to execute the JDBC example using JdbcRowSet instead of Using ResultSet?

Answer Question  Select Best Answer

How to get nth record from index by table?

vadivelraju

• Feb 17th, 2019

We can get like collection(n).column [Ex. emp(3).empno]

Answer Question  Select Best Answer

Tejas Makwana

• Feb 12th, 2007

DBMS includes the theoretical part that how datas are stored in a table. It does not relate tables with another. While RDBMS is the procedural way that includes SQL syntaxes for relating tables with a...

M.Mahesh Kumar

• Nov 24th, 2005

RDBMS is enabled nu static 2-dimensional tables. ADBMS is enabled by vector field and is n- dimensional.

Answer Question  Select Best Answer

ankit

• Mar 16th, 2007

jdbc.odbc

pranali patil

• Oct 19th, 2005

Its a jdbcodbc bridge

Answer Question  Select Best Answer

Sheraz Baig

• Nov 22nd, 2013

Subquery is basically Query Withing Query.. and the Result of Subquery is used by Outer query and Subquery could be at any level its not level restricted...

DIPTENDU HUI

• Jan 28th, 2006

1.Subquery is nothing but a query inside a query which appears only after the WHERE clause of a select statement.2.Two types of subquery is there:a) Co-Related subqueryb) Non-Co-related subquery.3. Us...

Answer Question  Select Best Answer

Nirali Dedhia

• Aug 15th, 2014

State and explain categories os specialization?

Gajanan K

• Jul 13th, 2007

Aggregation: Selecting the data in group of records is called aggregation. There are five aggregate system functions they are viz. Sum, Min, Max, Avg, Count. They all have their own purpose Decomp...

Answer Question  Select Best Answer

prakash

• Oct 30th, 2006

Perform is purely based on executionhow we get the result, ie Time , spped etcbutexecute is purely depends on logic of how we had done the design and code,itslike the output for given input for a written logic

anand sharma

• Sep 8th, 2006

what is the difference between perform and execute?

Answer Question  Select Best Answer

Madhu Kalla

 Profile Answers by Madhu Kalla Questions by Madhu Kalla

• Feb 10th, 2009

The subschema is the logical view of the data as it appears to the applications program

Dheeraj

• Aug 29th, 2006

In database management, an individual user's partial view of the database. The schema is the entire database.

Answer Question  Select Best Answer

zaneizane

 Profile Answers by zaneizane Questions by zaneizane

• Jul 22nd, 2008

This may be considered as the mapping of the data and data relations into an indefinitely large linear address space. This specifies some or all of the data structures necessary to support the data and data relations declared in the conceptual schema.

ALOK BATHAM VAISH

• Dec 24th, 2006

THhe overall design of the database is called Scheema.

Answer Question  Select Best Answer

indr

• Apr 6th, 2007

No up to 3nf it is not sufficient to normilize...coz 3nf contains redundancy problem....that can be removed by BCNF...so up to BCNF it is sufficient.....

Kalpesh Patel

• Jan 23rd, 2007

Third Normal Form is sufficient for most situations. But if that isn't normal enough for you.

Answer Question  Select Best Answer

Sheraz Baig

• Nov 22nd, 2013

GUI based

manishayadav_1

 Profile Answers by manishayadav_1 Questions by manishayadav_1

• Apr 9th, 2008

menu-driven

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

Post block trigger belongs to Navigational triggers.

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 24th, 2007

Navigation Trigger

Answer Question  Select Best Answer

Types of users with their duties using suitable examples

johnjustin

 Profile Answers by johnjustin Questions by johnjustin

• Apr 8th, 2008

There is no much difference between user and enduser. A person who uses a system or application is a user. If a software engineer uses Sql server for application development then the person is also ca...

abhay.parashar

 Profile Answers by abhay.parashar Questions by abhay.parashar

• Nov 19th, 2007

 The final or ultimate user of a computer system. The end user is the individual who uses the product after it has been fully developed and marketed. The term is useful because it distinguishes t...

Answer Question  Select Best Answer

Discuss the difference between unique and non-unique keys

mudkhedkar

 Profile Answers by mudkhedkar Questions by mudkhedkar

• Nov 7th, 2008

Unique - Take for example employee table, it has column empno which is called as unique key where as non-unique key is column workdept, i.e when we do relationship between two tables as employee & department tables, dept. table also contains deptno as column so it is called as non-unique key.

KamalChauhan

 Profile Answers by KamalChauhan Questions by KamalChauhan

• Jul 11th, 2008

Unique keys can have only one null value or rather i should say that every value in the column(which is marked as unique key) must be unique.

Answer Question  Select Best Answer

Why is the choice of primary key important and are three characteristics of an ideal primary key?

sanit kale

• Apr 24th, 2014

The PRIMARY KEY constraint uniquely identifies each record in a database table.

Primary keys must contain unique values.

A primary key column cannot contain NULL values.

Each table should have a primary key, and each table can have only ONE primary key.

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 16th, 2009

Primary key will let the retrieval operation to be fast.It will not allow you to insert duplicate and null values.It is used to uniquely identify a row in a table.

Answer Question  Select Best Answer

What is an intersection table and why is it important?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

An intersection table implements a many-to-many relationship between two business components.

scud021

 Profile Answers by scud021 Questions by scud021

• Jul 20th, 2008

A table added to the database to break down a many-to-many relationship to form two one-to-many relationships

Answer Question  Select Best Answer