Answer Posted / vsubbaiah
Select Distinct |fields * | from table name
where condition
group by column list
having grouped column
order by column
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How do we display rows from the table without duplicates?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is a lookup table in oracle?
How can we delete duplicate rows in a table?
Differentiate between pre-select and pre-query?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How do we get field detail of a table?
How to insert multiple rows with one insert statement in oracle?
How to assign a tablespace to a users in oracle?
What is the difference between alert log file and tarce file ?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is a oracle database?
What is the usage of control file in oracle?
How do we create privileges in oracle?
How can we find out the current date and time in oracle?
