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

Answer Posted / klkl

correct
select distinct(emp_name) from employees;

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster union or join?

488


What is sql*loader?

568


What is linq to sql?

550


Why self join is used in sql?

494


how to include character strings in sql statements? : Sql dba

551






What is query execution plan in sql?

563


what is the difference between myisam static and myisam dynamic? : Sql dba

581


What does 0 mean in sql?

526


how do you control the max size of a heap table? : Sql dba

532


How do you delete a table?

534


How do you update a value in sql?

545


What are the advantages of stored procedure?

536


What jobs use sql?

524


What does plv msg allows you to do?

673


What is trigger types in sql?

529