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

How do you explain an index?

1224

how to get a list of columns in an existing table? : Sql dba

916

Define sql delete statement.

955

Write a sql query to get the third highest salary of an employee from employee_table?

1029

Is inner join same as self join?

1063

what are date and time functions in mysql? : Sql dba

927

what is the difference between primary key and unique key? : Sql dba

972

How to know the last executed procedure?

1035

What is scalar data type in pl sql?

1020

What is dynamic query?

915

What is file based approach?

877

what is msql? : Sql dba

943

Does postgresql run on the cloud?

1080

Is subquery faster than join?

953

What is the difference between pl and sql?

1039