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
- 12223 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
how many display types available in sas bi dashboard? : Sas-bi
how can you import .csv file in to sas? : Sas programming
what r the job openings SAS for fresher graduates !
What are the prime responsibilities of data integration administrator? : Sas-di
explain about various caches available in data integrator? : Sas-di
Explain the purpose of retain statement.
What is the sas data set? : sas-grid-administration
what is the Population you used in your project, is it ITT or PP?
What are the features of SAS?
What are the statements that are executed only?
How to include or exclude specific variables in a data set?
Differentiate between sas functions and sas procedures.
What is the basic structure of the SAS base program?
what is the effect of the options statement errors=1? : Sas programming
What is the use of stop statement?
