I have a table .in the table 100 recored is there .we have
get the single row with out using clause..
Answers were Sorted based on User's Feedback
Answer / ajit
Select Rn, ename
From ( Select Rownum rn, Ename
From Emp
)
Where Rn = Nth;
Is This Answer Correct ? | 1 Yes | 6 No |
Answer / nannesaheb chinthalacheruvu
Question is not clear..kindly elaborate the same.
As i understand is "Retrive the single row with out using the where clause"...if so the below query may help you to achive the same.
Select e.*,max(rowid) from emp e;
select e.*,min(rowid) from emp e;
Is This Answer Correct ? | 2 Yes | 14 No |
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby
5 Answers HCL, JPMorgan Chase,
Explain cursor types?
i want run a sql query query? which phases are run in a back ground? pls tell me the answer
Which normal form is best?
What are the types of operators available in sql?
Explain sql data types?
What is a constraint?
What is procedure function?
what is the difference between delete and truncate statement in sql? : Sql dba
Explain correlated query work?
What is the difference between a primary key and a unique key?