Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / lince
select T.* from(
select row_number() over (order by salary desc)as rno,salary from table )T
where T.rno=100
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What is data manipulation language?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is compound trigger?
what are aggregate and scalar functions? : Sql dba
Show how functions and procedures are called in a pl/sql block.
What is a behavioral trigger?
What is the difference between database trigger and stored procedure?
Explain the difference in execution of triggers and stored procedures?
What is sap sql anywhere?
When can we use the where clause and the having clause?
Where the sql database files are stored?
what are myisam tables? : Sql dba
What is sql basics?
What is denormalization in a database?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
