This question asks "Get the row at 60% of the table". This seems pretty straightforward. If the table has 100 rows, return the 60th row. If it has 500 rows, return the 300th row.
For the non-10k users, here is the entire question:
Get the row at 60% of the table
I'd like to go to the 60% row in a table with oracle. I can find the number of the 60% row with:
select round(count(*)*0.60) as sira from (select to_date(time) as tarih,lenght as hiz from table order by length desc)
i.e I'll get name column data from table which row number.NOte:I will get name data after I ordering my table with
order by length desc
I was surprised when the question was initially closed, but now it has been deleted by a moderator. Why is this question considered "unclear", and why was it worthy of a moderator-delete?