I have a table .in the table 100 recored is there .we have
get the single row with out using clause..
Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of a sql?
What is trigger with example?
What is oracle pl sql developer?
Explain some predefined exceptions.
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
How many postgresql users are there, worldwide?
What is difference between stored function and application function?
What is the difference between in and between in sql?
What is sqlcommand?
When is the update_statistics command used?
Advantages and disadvantages of stored procedure?
Explain spool.
What is nosql vs sql?
How subquery works in sql?
What does pragma mean?