Interested to Buy Any Domain ? << Click Here >> for more details...
You have a data set of 100 observations,how can you
restrict the output so that the output has only data from
row no. 10 to row no. 20
- 9 Answers
- 11950 Views
- I also Faced
- E-Mail Answers
Answer Posted / amit gupta
SELECT *
FROM (SELECT ROWNUM srno, a.*
FROM emp a)
WHERE srno >= 10 AND srno <= 20
/
SELECT *
FROM (SELECT ROWNUM srno, a.*
FROM emp a)
WHERE srno between 10 and 20
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Give e an example of..
how would you determine the number of missing or nonmissing values in computations? : Sas programming
What does proc print, and proc contents are used for?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
Do you need to rearrange the order of the data for the report?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
name the scheduler for scheduling job and explain the scheduler? : Sas-di
What are common programming errors committed in sas
How to limit decimal places for the variable using proc means?
For what purposes have you used sas macros? : sas-macro
What is the basic syntax style in SAS?
How do you delete duplicate observations in sas?
what is study design in while working with SAS? what are screening variables in SAS?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
