Differences between UNIQUE and DISTINCT in select statements
Answer Posted / carol
unique is a constraint on coloumnsbut distinct is used in DML for query retrieval in select
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is data type in sql?
What programs use sql?
How does sql developer connect to oracle database?
What is the main reason behind using an index?
Why we use cross join?
how to return query output in html format? : Sql dba
What problem one might face while writing log information to a data-base table in pl/sql?
Can %notfound return null after a fetch?
What is sql*plus?
Can a select statement fire a trigger?
What are the types of sql commands?
What are the advantages of indexing?
What is compiled query?
What is the difference between an inner and outer join?