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
- 12145 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 difference between SAS functions and procedures?
what does the run statement do? : Sas programming
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
How do you specify the number of iterations and specific condition within a single do loop?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What are the data types does SAS contain?
Differentiate between format and informat? : sas-grid-administration
describe about physical data integration? : Sas-di
name the scheduler for scheduling job and explain the scheduler? : Sas-di
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
What is maximum number of rows and cols can be handled in SAS?
Explain what is the use of proc gplot?
What is the difference between INPUT and INFILE ?
which date functions advances a date time or date/time value by a given interval? : Sas programming
