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

Answer Posted / dinesh kumar

select distinct * from table_name;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a pragma statement?

721


explain about mysql and its features. : Sql dba

552


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

530


How to change sql*plus system settings?

544


What does plv msg allows you to do?

679






What is sql lookup?

513


What are different types of triggers?

559


What is program debugging?

564


What is full join?

531


What are the three pl sql block types?

571


What is the use of <> sql?

554


what are sequences

1094


Can sql function call stored procedure?

558


What is %type in pl sql?

540


What is the starting oracle error number?

565