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;

How many aggregate functions are available there in sql?

530

---

What is recursive join in sql?

552

---

What is the advantage of nosql?

530

---

what happens if null values are involved in expressions? : Sql dba

571

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

581

---

---

what is table? : Sql dba

576

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

620

---

What is a sql instance vs database?

582

---

Does truncate table reset auto increment?

528

---

Who is the owner of mysql database?

555

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

647

---

what is 'mysqlshow'? : Sql dba

593

---

what is a table in a database ? : Sql dba

546

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1158

---

What is the use of partition by in sql?

521

---