how to create temparary sequence

Answer Posted / shipra

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between between and in condition operators?

727


What are records give examples?

743


What is difference between sql and mysql?

751


What sql database should I use?

788


What is where clause in sql?

734






How can you create an empty table from an existing table?

799


what is a record in a database ? : Sql dba

764


what are date and time data types in mysql? : Sql dba

689


What is sql comments?

813


Why is sql better than hql?

689


What does varchar include?

683


How can we implement rollback or commit statement in a trigger?

789


How is pl sql different from sql?

727


What are all the different normalizations?

745


What are the basic sql commands?

749