select * from emp x where &n=(select count(distinct sal) 
from emp y where x.sal<=y.sal)

it will prompt for the value give the values as 10 u will 
get the output

select * from emp a
where (select count(distinct sal) from emp b where
a.sal<b.sal)=&n order by sal desc
/


this is the exact query........when there are duplicate
salaries are there also........

To find nth value

select salary from emp a where &n=(select count(distinct
salary) from emp b where a.empno<=b.empno);

to find max by nth value a.empno<=b.empno
to find min by nth value a.empno>=b.empno

OR

To find 10 max records 

select * from (select * from emp order by salary desc) where
rownum<=&n;

To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;

select * from (select rownum r,emp.* from emp) where r=3;

surrogate key: It has system generated artificial key
values, which allows to maintain historical records in the
data warehouse more effectively.

Parameter:Specifies the parameter that is satisfied by 
values chosen in the prompt control.

Applies to
Date & Time Prompt, Date Prompt, Generated Prompt, Interval 
Prompt, Select & Search Prompt,
Text Box Prompt, Time Prompt, Tree Prompt, Value Prompt

Macro:A macro is a runtime object, which uses the parameter 
maps and sesssion parameters in developing the conditional 
query subjects.

Filter: A filter is a condition which restricts the amount 
of data displayed in the report.

Condition:An expression that yields a boolean value. 
Conditions are used in query expressions, query filters, 
and boolean report variables that can be used for 
conditional formatting, styles, data sources, layouts and 
blocks.

Filter is a condition which restricts the amount 
of data displayed in the report.

Eg: You have history data from year 2000 to 2008. But
your report is to display only the "monthly trend for year 
2007", in such scenario you will have to put filter in year 
= 2007.
-palz-

Primary key,Secondary key,Candidate Key or Alternate 
key,Composite key or concatenate key,Sort Or control 
key,Foreign Key.

use sorter transformation with ascending,sequence and filter....

if it is flat file ur answer is write,if it is relational 
souce then go to source qualifier properties there u write 
the query like
   select distinct a.* from t1 a where 10=(select sal from 
t1 b where a.sal>b.sal)
  i think it is working

only use the Aggregator function.....
   
    first(sal>=values)

SQL:
SELECT id, salary from <table name> where rownum <= 10
       ORDER BY salary DESC;

it can achieve with inline view query in sqt/r

by using Initcap function

We can get this one by using upper(substr(name,1,1))

by using expression transformation ...we can use this function  
 init caps...

by using initcaps() function in exp tansformation

Find the space by using the Instr() function and then split 
into two.. then merge.

it is very simple by using expression trans

How can you say which is thir record when all the salaries 
are same...

We can do this by adding the rownum pesudo coulmn in the sql
overrider and take the thrid one since all the values are same,

like select col1,col2,rownum
from tab1
where rownum=3

Based on the empid(assuming the persons are employees) us 
can fire a quiry on that id.

hi all,
 suppose 4 emp geting same sal as 4000... select * from emp 
where sal=4000 and/having rowid=3

Hi pooja,

would rowid be 3?
can u use having clause in ur query?

pl let me know poojaa

If you have any update date column in ur table, u can query 
where sysdate-2 to get the last two days records.

By using the Sequence generator and Mod() in Expression tfn.