Answer Posted / nilesh

hi all,

This will also work fine, try it

select top 1 * from (select top 2 * from table_name)as set
order by set.col_name desc

here table_name is the name of the table from which
you want to retrive the record.
And col_name is the column name by which you are sorting
the records

If it found wrong plz correct it....
and show it on this site

How do you declare a variable in pl sql?

1032

---

Explain table and field in sql?

1068

---

What is the use of pl/sql table?

1070

---

What is not null in sql?

1061

---

What are actual parameters and formal parameters?

1107

---

define sql update statement ? : Sql dba

1126

---

Is progress software supports to ( pl/sql )?

1042

---

What is data profiling in sql?

1085

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1271

---

What is the purpose of cursors in pl/sql?

1138

---

What does pl sql developer do?

935

---

What does select top 1 do in sql?

1102

---

How do I partition in sql?

968

---

What is pragma in pl sql?

1118

---

explain what is mysql? : Sql dba

1088

---