select distinct

write sub query for eliminating duplicate rows using
analytical function?

Question Posted / guest

Answer Posted / guest

select distinct

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is merge a dml statement?

971

Can we join tables without foreign key?

955

how to use like conditions? : Sql dba

1100

What is having clause in sql?

957

What is foreign key sql?

979

What is sql mysql pl sql oracle?

1063

what are wild cards used in database for pattern matching ? : Sql dba

1132

What is plpgsql language?

1055

How do you break a loop in pl sql?

1039

What is mdf ldf and ndf?

989

What is the use of triggers?

1031

How do you write a complex sql query?

1051

Can we rollback truncate?

994

how would you enter characters as hex numbers? : Sql dba

974

Difference between truncate, delete and drop commands?

1078