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

Is nosql faster than sql?

542


What is full join?

530


What is sqlerrm?

547


What does pl sql stand for?

655


Is primary key clustered or nonclustered?

561






What is recursive stored procedure?

601


What is the difference between between and in condition operators?

534


What is meant by <> in sql?

506


How do you use collections in procedure to return the resultset?

1788


Which is faster union or join?

493


What do you mean by query optimization?

548


What is primary and foreign key?

592


What is difference between db2 and sql?

532


What is the difference between delete, truncate and drop command?

549


how to shutdown mysql server? : Sql dba

566