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
23220 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

Why commit is not used in triggers?

990

What is meaning of <> in sql?

1016

When sql appeared?

1022

How would you pass hints to the sql processor?

919

what is log shipping? : Sql dba

1055

What is the difference between delete and truncate statement in sql?

1008

What is the difference between inner join and left join?

935

What is offset in sql query?

1068

What are pl sql data types?

950

Why indexing is needed?

939

What is the execution plan in sql?

971

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

930

What is the purpose of using pl/sql?

1075

Is inner join faster than left join?

1123

What is 19 null in sql?

894