for 2nd: select * from table where rownum<8 minus select * from table w

1) In a dataset how to delete a single row?
2) i have 50 rows , i want to display 5-7 records only?
How to write the sql query?
3)i have 40 rows,i want to display last row? write sql query?

Question Posted / sarath

7 Answers
19887 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / sarath

for 2nd:
select * from table where rownum<8 minus select * from table where rownum<5;

Is This Answer Correct ?

4 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How complex jobs are implemented in datstage to improve performance?

1036

How the ipc stage work?

1124

in oracle target stage when we use load option and when we use upsert option?

2277

What is the difference between orabulk and bcp stages?

1023

What is active and passive stage?

1410

what is use of SDR function?

5169

Which warehouse using in your datawarehouse

2182

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2857

What is the flow of loading data into fact & dimensional tables?

1059

Difference between data warehousing and olap?

1089

Explain how a source file is populated?

1362

how to add a new records into source?

1996

Describe the architecture of datastage?

1001

What are the different type of jobs in datastage?

1041

What are the types of containers?

1227