answer for 3rd question: select * from emp where rowid =(select max(rowi

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 / segu satish

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

Answer Posted / segu satish

answer for 3rd question:

select * from emp where rowid =(select max(rowid) from emp)

Is This Answer Correct ?

13 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the various kinds of containers available in datastage?

974

What is the difference between operational data stage (ods) and data warehouse?

1176

how can we create rank using datastage?what is the meaning of rank?

8705

How do y read Sequential file from job control?

15797

Whats difference betweeen operational data stage (ods) and data warehouse?

1069

Which warehouse using in your datawarehouse

2116

What are the main differences you have observed between 7.x and 8.x version of datastage?

1023

What are the types of containers and how to create them?

931

CHANGE CAPTURE

1257

How many Key we can define in remove duplicate stage?

1310

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1368

explain about citrix scheduling tool in datastage

2379

What are the important features of datastage?

1048

What is a merge in datastage?

1200

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1684