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;

What is multiple partition?

962

---

What is sqlservr exe?

973

---

define data blocks ? : Sql dba

975

---

What port does sql server use?

1056

---

Why cross join is used?

1074

---

Explain unique key in sql.

1001

---

What is a record in pl/sql?

1137

---

What is a stored procedure in sql with example?

1120

---

Can we commit in trigger?

962

---

What are the rules to be applied to nulls whilst doing comparisons?

1321

---

Is sql procedural language?

961

---

Can we use commit inside a trigger?

1080

---

explain primary keys and auto increment fields in mysql : sql dba

969

---

Why do we use function in pl sql?

1055

---

What is the difference between local and global temporary table?

1037

---