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

what are ddl statements in mysql? : Sql dba

1173

---

What are the ways on commenting in a pl/sql code?

1113

---

what is index? : Sql dba

988

---

What is the difference between inner join and natural join?

988

---

Why stored procedures are faster than query?

1006

---

What is attribute indicator in pl sql?

1000

---

What are the syntax and use of the coalesce function?

1179

---

What is pl sql block structure?

1015

---

What do you mean by “trigger” in sql?

1054

---

describe transaction-safe table types in mysql : sql dba

986

---

how to install mysql? : Sql dba

1090

---

What are the operators in sql?

1000

---

How many indexes can be created on a table in sql?

1035

---

Can we debug stored procedure?

1010

---

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

2244

---