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
- 23747 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / yaswanth
select salary from emp where rowid NOT IN(select max(rowid) from emp GROUP BY salary);
| Is This Answer Correct ? | 14 Yes | 7 No |
Post New Answer View All Answers
how to install mysql? : Sql dba
What is data control language (dcl)?
How does rowid help in running a query faster?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What are types of joins?
how many values can the set function of mysql take? : Sql dba
What are the disadvantages of file system?
What are some emotional triggers?
When do we use triggers?
Why are aggregate functions called so?
What is sap sql?
Determine if oracle date is on a weekend?
What is the importance of sqlcode and sqlerrm?
what are the different type of normalization? : Sql dba
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
