adspace


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

If a cursor is open, how can we find in a pl/sql block?

1252


Can we rollback truncate?

1083


Is primary key always clustered index?

1101


what is schema? : Sql dba

1163


what is collation? : Sql dba

1242


What is the best sql course?

1062


What is your daily office routine?

2351


What is the current version of postgresql?

1188


what are the advantages of sql ? : Sql dba

1154


Is inner join faster than left join?

1287


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2099


what is dbms? : Sql dba

1070


How do I remove duplicates in two columns?

1202


Does group by remove duplicates?

1120


Can we use distinct and group by together?

1146