write sub query for eliminating duplicate rows using
analytical function?
Answer Posted / guest
select distinct
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How many tables can a sql database have?
Can pl sql procedure have a return statement?
Whis is not false in primary key?
how to get a list of columns in an existing table? : Sql dba
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What are sql functions? Describe in brief different types of sql functions?
what are date and time data types? : Sql dba
Can we use delete in merge statement?
What are the ddl commands?
what is subquery? : Sql dba
How to move files from one directory to another in pl sql?
What are the types of join and explain each?
Can we use distinct and group by together?
What is the difference between clustered and non-clustered index in sql?
What is int identity in sql?