Interested to Buy Any Domain ? << Click Here >> for more details...
take one table is t1 and in that column name is f1
f1 column values are
200
5000
3000
7000
300
600
100
400
800
400
i want display the values asc and desc in a single output.
sample output is
f1.a
100
200
300
400
500
600
etc......
and f1.d is
5000
4000
3000
2000
1000
etc...
- 9 Answers
- 12224 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / sumathy
Create table as 'f_order' with coulmn f1.
Run the following statement to get the above quesion's
results.
DECLARE @a INT, @b int
DECLARE @f1 CURSOR, @f2 CURSOR
Print 'Ascending '
SET @f1 = CURSOR FOR
SELECT f1
FROM f_order order by 1 asc
OPEN @f1
FETCH NEXT
FROM @f1 INTO @a
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @a
FETCH NEXT
FROM @f1 INTO @a
END
CLOSE @f1
Print 'Descending '
SET @f2 = CURSOR FOR
SELECT f1
FROM f_order order by 1 desc
OPEN @f2
FETCH NEXT
FROM @f2 INTO @b
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT @b
FETCH NEXT
FROM @f2 INTO @b
END
CLOSE @f2
DEALLOCATE @f1
DEALLOCATE @f2
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is the starting oracle error number? What is meant by forward declaration in functions?
Why are cursors used?
In a distributed database system, can we execute two queries simultaneously?
What is a schema sql?
Which type of cursor is used to execute the dml statement?
What are sql*plus environment variables?
What is a dynamic query?
What are analytical functions in sql?
Can we call stored procedure in function?
What is bitemporal narrowing?
What is pl/sql table? Why it is used?
How do I remove sql plus from windows 10?
What is use of package in pl sql?
How do I run a pl sql program?
Why do we need cursors in pl sql?
