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
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
How sas treats the dsd delimiters?
what are informats in sas? : Sas-administrator
What are pdv and it functions?
do you need to know if there are any missing values? : Sas programming
What is the difference between INPUT and INFILE ?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
Explain data step in SAS
Give e an example of..
Explain the main difference between the sas procedures and functions? : Sas-administrator
How would you include common or reuse to be processed along with your statements?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
What are SAS/ACCESS and SAS/CONNECT?
how will you locate the sas platform applications? : Sas-bi
describe about metadata object? : Sas-di