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
- 24034 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / priya
select DISTINCT sal from emp;
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is a database trigger?
What is record type in pl sql?
Is id a reserved word in sql?
Can we alter stored procedure?
Explain the difference between drop and truncate commands in sql?
Why do we create views in sql?
what are rollup and cube in t-sql? : Transact sql
Can you select everything, but 1 or 2 fields, without writer's cramp?
What packages are available to pl/sql developers?
What is denormalization in a database?
Explain ttitle and btitle.
How does pl sql work?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How do I truncate a sql log file?
What is the use of nvl function?
