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
- 12483 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
what is the purpose of _error_? : Sas programming
Hi, If anyone has base SAS certification dumps, please share.
Explain by-group processing?
Explain how merging helps to combine data sets.
What is factor analysis?
How many ways to overcome a missing values???
What is SAS informats?
What commands are used in the case of including or excluding any specific variables in the data set?
Give e an example of..
What are the functions which are used for character handling functions?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
how can you put a "trace" in your program? : Sas programming
How would you identify a macro variable?
How would you define the end of a macro?
what is the use of sas management console? : Sas-di
