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

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3550


what are the different type of sql's statements ? : Sql dba

522


Which are sql * plus commands?

539


Is json a nosql?

541


How many sql statements are used?

569






What does (+) mean in sql joins?

526


Why do we use view in sql?

534


What is cross join example?

556


how to escape special characters in sql statements? : Sql dba

514


What is group function in sql?

538


Are null values same as that of zero or a blank space?

533


How can you tell the difference between an index and a view?

493


Explain what is sql*plus?

670


What is memory optimized?

556


Where is sql database stored?

520