topic Re: Nested query from SQL - ABAP in Application Development and Automation Discussions

Nested query from SQL - ABAP

Former Member — Tue, 25 Nov 2008 10:38:43 GMT

Hi,

Suppose I have a table with columns Id and Name, and I want to get

rows 6 to 10 (both inclusive) of that table, in sql I would write query

select top 5 Name, Id from (

select top 10 Name, Id from MyTable order by Id

) as student order by Id desc

Can anyone tell me how to write this nested query in ABAP ?

Thanks,

Srini.

Re: Nested query from SQL - ABAP

Former Member — Tue, 25 Nov 2008 10:42:08 GMT

I think u shd select all the data.

and moidfy ur internal table with sy-tabix.

Regards

Rasheed

Re: Nested query from SQL - ABAP

Former Member — Tue, 25 Nov 2008 10:46:19 GMT

Hi,

I want to do it in the query level itself.

Thanks,

Srini.

Re: Nested query from SQL - ABAP

Former Member — Tue, 25 Nov 2008 10:47:25 GMT

Please tell your requirement clearly,

if you are selecting the values from same table you dont need to write nested select queries.

if you are using more than one table better you go for FOR ALL ENTRIES or INNER JOINS

still if you want use aggregate functions like MAX COUNT etc

regards

Ramchander Rao.K

Re: Nested query from SQL - ABAP

Former Member — Tue, 25 Nov 2008 10:48:46 GMT

Hi,

Try this,

var1 = 6

var2 = 10

select * from table to itab.

delete itab where sy-tabix >var2 and sy-tabix < var1.

required data is in itab

Re: Nested query from SQL - ABAP

Former Member — Tue, 25 Nov 2008 10:54:01 GMT

I think in the query level u cant do u can select upto n rows. but u can take ranges for rows.

after selecting the data . loop to tht internal table and delete the records and modify tht internal table.

if u find the solution in query level u can post in SDn

Regards

rasheed

Re: Nested query from SQL - ABAP

Former Member — Tue, 25 Nov 2008 11:04:38 GMT

Hi,

I couldn't get the desired result in the form of nested queries.

But by reading n rows and deleting it using sy-tabix i got the solution. (Solution by Shwethali)

Thanks,

Srini.