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 a secondary key the same as a foreign key?

1116

---

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

1166

---

How many parts of a pl sql block are optional?

1219

---

What is compilation error in pl sql?

1025

---

how to calculate the difference between two dates? : Sql dba

1115

---

What is a pdo connection?

1115

---

What is sql scripting?

1194

---

What is normalisation and its types?

1044

---

how to include comments in sql statements? : Sql dba

999

---

How many sql databases can you have on one server?

1153

---

Does execute immediate commit?

1291

---

What is rank () in sql?

997

---

Which is faster truncate or drop?

1101

---

What are the query optimization techniques?

1000

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1012

---