Answer Posted / shipra

select rownum seq
, name
, age
from ( select name
, age
from your_table
order by name
)

What is difference between rank () row_number () and dense_rank () in sql?

1097

---

When sql appeared?

1087

---

Is there a 64 bit version of ssms?

956

---

What is thread join () in threading?

1005

---

What are the different types of constraints?

1171

---

What is the use of & in pl sql?

1038

---

How do I access sql anywhere database?

969

---

How do I edit a stored procedure?

988

---

What is the difference between join and natural join?

927

---

What is relationship? How many types of relationship are there?

1171

---

How to Declare Fixed Length String Value In PL SQL

1150

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

1008

---

What is the difference among union, minus and intersect?

992

---

What is the use of desc in sql?

973

---

how to drop an existing table in mysql? : Sql dba

1042

---