what eliminate duplicate without using roenum and not

Answer Posted / gourav

we can use distinct keyword for elaminate duplicat rows

select distinct(salary)from emplpyees

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is percent sign in sql?

713


What are data types in pl sql?

553


Define a temp table?

549


What are pl/sql cursor exceptions?

568


what is timestamp in mysql? : Sql dba

559






What is pl sql quora?

638


how to create a test table in your mysql server? : Sql dba

491


How to load data with sql*loader?

546


What are the usages of sql?

560


Is sql injection illegal?

593


What is a data definition language?

548


What is sap sql?

532


Is trigger a stored procedure?

498


Does postgresql run on the cloud?

585


Why we use pl sql?

527