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

What are the two parts of design view?

683


Why is pl sql used?

625


How does pl sql work?

605


how can we optimize or increase the speed of a mysql select query? : Sql dba

594


Explain constraints in sql?

680






Explain commit, rollback and savepoint.

695


What is foreign key sql?

656


write an sql query to find names of employee start with 'a'? : Sql dba

676


what are the non-standard sql commands supported by 'mysql'? : Sql dba

664


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

650


Does mysql_real_escape_string prevent sql injection?

624


What is java sql driver?

636


Is oracle sql free?

644


What is a database? Explain

688


What is normalization in sql?

622