select distinct(SAL) as SAL from table

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 only how should u
write query?

Question Posted / yaswanth

9 Answers
11334 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / yaswanth

select distinct(SAL) as SAL from table_name;

Is This Answer Correct ?

17 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the uses of a database trigger?

1086

How to start the command-line sql*plus?

1109

What is sp_helptext?

1110

What are the different dml commands in sql?

1247

Why we use sql profiler?

1023

How is a PL/SQL code compiled?

1283

What is ttitle and btitle?

1113

Can we have two clustered index on a table?

1078

What are the indexing methods?

1098

What are the different types of sql commands?

1176

What are different methods to trace the pl/sql code?

1168

What is sqlcommand?

1071

What is a sql*loader control file?

1341

Is primary key clustered index?

992

How does postgresql compare to "nosql"?

1084