Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table .in the table 100 recored is there .we have
get the single row with out using clause..
- 3 Answers
- 9437 Views
- I also Faced
- E-Mail Answers
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
How to install oracle sql developer?
How can you load multi line records? : aql loader
What is rank function in sql?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What are pl/sql cursors?
What is delimiter sql?
What are the different dcl commands in sql?
Can we write dml inside a function in sql server?
What is a behavioral trigger?
What is update query?
What is before trigger?
What is meant by <> in sql?
How do you modify a trigger?
What is range partitioning?
How many commands are there in sql?
