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

Which join is like inner join?

561


what is a unique key ? : Sql dba

547


Advantages and disadvantages of stored procedure?

580


What is the difference between a subquery and a join?

529


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

539






How do I count rows in sql?

561


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

563


What is %type in sql?

513


What is the most restrictive isolation level? : Transact sql

556


Which join is default?

519


What is the use of function in sql?

539


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

621


What is the source code of a program?

507


What are the operators used in select statements?

578


How delete all records from table in sql?

554