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 clustered index sql?

503

explain advantages of innodb over myisam. : Sql dba

646

How many types of normalization are there?

487

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2004

How many databases can sql express handle?

532




Can we commit inside a trigger?

547

What is sqlite used for?

528

What is forward declaration in pl sql?

588

What does a pl/sql package consist of?

516

Explain what is a field in a database and record in a database?

606

what are the types of subquery? : Sql dba

586

What type of database is sql?

613

State few characteristics of pl/sql?

565

explain what is mysql? : Sql dba

598

What are the types of optimization?

519