Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 13 Answers
- 23712 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / muthukumar
Select Sal From Emp
Group By Sal
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is where clause in sql?
How to avoid duplicate records in a query?
What are primary key and foreign key and how they work?
What is the basic structure of an sql?
How to use boolean type in select statement?
Explain how exception handling is done in advance pl/sql?
What is a sql select statement?
how to get a list of indexes of an existing table? : Sql dba
How do you declare a user-defined exception?
Which are the different character-manipulation functions in sql?
Explain polymorphism in pl/sql.
What is the difference between rename and alias?
What is a native sql query?
how many ways to get the current time? : Sql dba
What is a constraint?
