You are spliting the data by Partition and assigning row numbers.

After that for row_number> 1 you are assiging blank right.

Is my understanding is correct?

Hi Kingston,

It is working. Just give me small explanation how this code is working..... If you explain it would be great help.

Thanks vidya..I'll use kingston's suggestion.. That is the best one.... Thanks a lot

First of all, Thanks to kingston....

Really rocked. This is really help ful.

Do I need to change the trigger function also, I can. This is my req.

Please help on this....

Now I'll tell you clearly...

I am having employee table.

Suppose If today 10 new joinees Joined. So I'll add through Insert statement.

SO I will give 10 insert statement. right?

But here I...

Now I'll tell you clearly...

I am having employee table.

Suppose If today 10 new joinees Joined. So I'll add through Insert statement.

SO I will give 10 insert statement. right?

But here I...

When it will be deleted automatically?

If I am creating global temporary table. it will not deleted once i disconnect the server? or if any one using at that time only it will not be deleted?

Can I declare a temp table outside the procedure and call it inside the procedure?

In procedure we can create a temp table?

Nothing.

Thanks kingston.

Hi Kingston,

Just for curiosity asking, can we handle the tie value in Row_number()?

No specific reason? I want to handle the tie value also. that's why? can we handle tie value also in row_number?

Thanks buddy...It is working.... Thanks a lot.

I guess DENSE_Rank is the better way. I don't like to use Row_Number. Thanks for the answer.

Select Salary from Table1 Where Salrank='3' Where (Select Dense_Rank()

over (Order By Salary Desc)...