how to retrive only second row from table?

Answer Posted / hema

Both the above answers give no correct result..

The first says bind variable should be declared for :n,
and second gives no rows selected...

Is This Answer Correct ?    34 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a foreign key have a different name?

517


what are the limitations of identity column? : Transact sql

610


How do you create a db file?

528


Is a foreign key always unique?

538


How do I turn a list into a table?

518






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

1781


List the various privileges that a user can grant to another user?

587


Why do we need cursor in pl sql?

655


how to convert character strings to dates? : Sql dba

530


What is cte sql?

523


What is a procedure in pl sql?

555


What are the subsets of sql?

553


What is character functions?

560


What are the various restrictions imposed on view in terms of dml?

529


Does a primary key have to be a number?

524