In table three columns with 1 milion records(here there is
no sequence values) i want add one more column with
sequence values from the first how it is posible?
Answer Posted / kondeti srinivas
select rownum,tablename.* frome tablename;
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the trigger in sql?
What is clustered index in sql?
What is fmtonly in sql?
Can we use rowid as primary key?
What is sql entity?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What are the main features of cursor?
What is the command used to fetch first 5 characters of the string?
how are mysql timestamps seen to a user? : Sql dba
What is database migration?
Is sql the best database?
What is procedure function?
Why is pl sql used?
How to know the last executed procedure?
Can we join tables without foreign key?