How will you select unique values from a list of records?

Answer Posted / rakesh

select distinct * from emp;

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are all the different types of indexes?

624


How do I run a sql query in pgadmin 4?

548


Which is better varchar or nvarchar?

550


What are the key differences between SQL and PL SQL?

628


What pl/sql package consists of?

638






how to do backup entire database? : Transact sql

615


What is the difference between joins?

536


How do I save a sql query?

546


Why commit is not used in triggers?

582


What does truncate mean in sql?

534


What is sqlcontext?

551


what are the different functions in sorting an array? : Sql dba

581


Which join is like inner join?

561


What is the use of sqlerrd 3?

521


What is difference between ms sql and mysql?

476