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

How can we make an if statement within a select statement?

736


What is a mutating table and a constraining table?

758


Is pl sql still used?

684


What is the difference between distinct and unique in sql?

654


How do I pipe the output of one isql to another?

722






What is the use of stored procedures?

708


What is left join in sql?

753


How to take user input in pl sql?

894


What is a sql select statement?

765


Is natural join and inner join same?

654


Define the select into statement.

778


Why stored procedure is better than query?

690


What are all the different types of indexes?

815


How many types of triggers exist in pl/sql?

730


What do we need to check in database testing?

726