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
19690 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

What is a merge?

1094

What is the difference between hashfile and sequential file?

1207

Which commands are used to import and export the datastage jobs?

1373

What is the purpose of pivot stage?

1114

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1347

How to perform incremental load in datastage?

1151

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1380

What are the different plug-ins stages used in your projects?

1047

Differentiate between data file and descriptor file?

1007

Is the value of staging variable stored temporarily or permanently?

947

Why do you need stage variables?

1144

Define APT_CONFIG in Datastage?

1039

What are orabulk and bcp stages?

1083

What is the differentiate between data file and descriptor file?

1320

What are stage variables?

1154