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


Please Help Members By Posting Answers For Below Questions

Can we have two clustered index on a table?

756


Which is faster joins or subqueries?

708


Why use truncate instead of delete?

715


what is table? : Sql dba

758


what is a primary key? : Sql dba

738






What is the meaning of disabling a trigger?

821


What are hotfixes and patches?

687


In a distributed database system, can we execute two queries simultaneously?

748


What is trigger explain it?

733


What are the basic techniques of indexing?

771


Why use stored procedures?

766


Sql technical questions

992


What are the uses of sysdate and user keywords?

837


Explain what is an index?

750


how to drop an existing view in mysql? : Sql dba

786