how to create temparary sequence
Answers were Sorted based on User's Feedback
Answer / shipra
select rownum seq
, name
, age
from ( select name
, age
from your_table
order by name
)
| Is This Answer Correct ? | 3 Yes | 0 No |
What is Pragma EXECPTION_INIT ? Explain the usage ?
What is the sql case statement?
How many types of sql are there?
How do you know if a relationship is 2nf?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is identity column in sql server?
What is difference between procedure and trigger?
What are reports usually used for?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is meaning of <> in sql?
What is prepared statement in sql?
What is use of trigger?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)