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

Answer Posted / suma

select distinct(emp_name) from employees;

Is This Answer Correct ?    27 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic techniques of indexing?

676


What is int identity in sql?

664


how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

607


Is sql the best database?

593


What is snowflake sql?

693






How to prepare for oracle pl sql certification?

686


What is difference between stored function and application function?

674


Can a select statement fire a trigger?

765


What are the two types of exceptions.

720


What is gpt format?

604


How do you identify a primary key?

723


How many types of index are there?

635


What are the possible values that can be stored in a boolean data field?

610


What does := mean in pl sql?

654


What is java sql connection?

601