http://www.youtube.com/watch?v=3bCgGrEz8Kw&NR=1

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

13 Answers
24031 Views
Cap Gemini, TCS, I also Faced
E-Mail Answers

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

Can we create view in stored procedure?

1026

What is a nested table in word?

1009

What is varchar example?

1080

Does oracle use sql?

992

Can we join more than 2 tables in sql?

1094

Explain constraints in sql?

1088

What is the purpose of the partition table?

1089

Can you have more than one key in a database?

995

How do I access sql anywhere database?

1023

Does truncate free space?

1065

What are the disadvantages of file system?

1364

What is triggering circuit?

1108

How do I quit sql?

1007

Is record in pl sql?

1013

What is break?

1257