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
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
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
Explain what is data step?
How substr function works in sas?
Difference between nodup and nodupkey options?
How long can a macro variable be? A token? : sas-macro
What are the difference between the sas data step and sas procs?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
what are the component of range? : Sas-bi
What are the data types does SAS contain?
What is the role of sas grid administrator? : sas-grid-administration
What is substr function?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What is interleaving in SAS?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5