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
- 12445 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
How can you tell the difference between an index and a view?
What is the difference between cross join and natural join?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
how many triggers are allowed in mysql table? : Sql dba
what is log shipping? : Sql dba
What is auto increment feature in sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What types of commands can be executed in sql*plus?
What do you mean by field in sql?
What is a recursive stored procedure?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is difference between stored procedure and trigger?
What is on delete set null?
Why functions are used in sql?
Why are cursors used?
