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

Is primary key a clustered index?

960

---

What is a heap in sql?

1049

---

What is sql comments?

1062

---

how can we destroy the cookie? : Sql dba

998

---

Is sql procedural language?

954

---

What is %type in sql?

949

---

What is pls_integer in pl sql?

1074

---

What is the difference between a query and a report?

953

---

What is sqlcommand?

1013

---

how to fetch alternate records from a table? : Sql dba

1089

---

Whis is not false in primary key?

1445

---

is it possible to pass an object or table to a procedure as an argument?

1109

---

What is posting?

1027

---

what does myisamchk do? : Sql dba

1004

---

What is raw datatype in sql?

1030

---