Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

one of the column in my table contains the data like
SAL
----
1000
1000
2000
3000
3000

So my requirement is i want output like
SAL
---
1000
2000
3000

it mean i want to delete duplicate rows in the table
permanently and i want output in the above formatow should u
write query?

Question Posted / guest

Answer Posted / guest

http://www.youtube.com/watch?v=3bCgGrEz8Kw&NR=1
bug
http://www.youtube.com/watch?v=zZdQ6HXXDiE&feature=related
levels of testing
http://www.youtube.com/watch?v=osgaXV4qtZg
software testing

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is unique key constraint? : Sql dba

748

Can you do multiple joins in sql?

730

What is rownum in sql?

762

What is the difference between the conventional and direct path loads? : aql loader

911

define data blocks ? : Sql dba

736




What are triggers in sql?

751

What is dialect in sql?

704

What does sql stand for?

704

How can you fetch first 5 characters of the string?

711

Does view contain data?

788

List and explain the different types of join clauses supported in ansi-standard sql?

1032

Is it important to partition hard disk?

747

What is primary key secondary key alternate key candidate key?

766

Why triggers are used?

747

What is crud stand for?

746