Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / monika
SELECT * FROM(SELECT a.*,row_number() over(ORDER BY NULL)
rn FROM emp a)
WHERE rn=2
| Is This Answer Correct ? | 18 Yes | 6 No |
Post New Answer View All Answers
What is the difference between cluster and non-cluster index?
Can we delete column in sql?
Does user triggers have entry for trigger with compilation errors?
how is exception handling handled in mysql? : Sql dba
how to convert character strings to dates? : Sql dba
How to process query result in pl/sql?
What does select * from mean in sql?
What are sql data types?
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 the usage of when clause in trigger?
What is a sql*loader control file?
How do you get column names only for a table (sql server)?
what are different types of collation sensitivity? : Sql dba
What is sql architecture?
What is oracle and pl sql?
