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

what is column? : Sql dba

1002

What is coalesce sql?

996

What are different types of triggers?

1107

What is rownum and rowid?

1030

How to return an array from java to pl/sql?

1132

Explain exception handling in pl/sql?

1033

Can we create view in stored procedure?

956

What has stored procedures in sql and how we can use it?

1079

Why join is faster than subquery?

1107

What are the types of keys?

991

what are the differences between char and nchar? : Sql dba

1113

Which is faster view or stored procedure?

943

Why do we need cursor in pl sql?

1132

Why stored procedure is better than query?

944

Why use triggers in sql?

955