Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between UNIQUE and DISTINCT in select statements
- 26 Answers
- 135713 Views
- ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
- E-Mail Answers
Answer Posted / narendrasai
UNIQUE: it is a constraint and it was created at the time of table creation, where as
DISTINCT: it is a word used at the time of selection.
So both are same, but usage of both the words are different
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What problem one might face while writing log information to a data-base table in pl/sql?
Explain 3 basic parts of a trigger.
how do you know if your mysql server is alive? : Sql dba
What is a trigger in sql?
When to use inner join and left join?
How to write pl sql program in mysql command prompt?
What is the cause of mutating table error and how can we solve it?
How to run sql statements with oracle sql developer?
Is sql free?
What is function and procedure?
C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.
what are sequences
What is write ahead logging in sql server?
What is the difference between drop and truncate commands?
how to concatenate two character strings? : Sql dba
