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
23765 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 bcp? When is it used?

1124

is it possible to pass an object or table to a procedure as an argument?

1144

what are myisam tables? : Sql dba

1042

How to check if a column is nullable before setting to nullable?

1138

Define a temp table?

1031

What is pl sql commands?

1054

What is bulk collect in pl sql?

1105

Is natural join and inner join same?

935

Is sql a case sensitive language?

953

How to assign sql query results to pl sql variables?

1090

What is pessimistic concurrency control? : Transact sql

1099

Does view store data in sql?

973

Do foreign keys improve performance?

1029

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1103

What are the subsets of sql?

1144