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 can you know that statistics should be updated?

1079

---

What is the use of prepared statement?

1025

---

how to rename an existing column in a table? : Sql dba

1020

---

How do you take the union of two tables in sql?

986

---

What is mdb stand for?

1011

---

how to create a new view in mysql? : Sql dba

938

---

Is primary key an index?

992

---

What are the limitations of sql express?

1071

---

What is the difference between clustered and non-clustered indexes?

1093

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2170

---

What are different types of indexes?

1011

---

Can we update views in sql?

940

---

how would you get the current date in mysql? : Sql dba

967

---

What is nosql example?

1035

---

what is bcp? When is it used?

1113

---