Difference between rowid and rownum in SQL?



Difference between rowid and rownum in SQL?..

Answer / yash

the difference between ROWNUM and ROWID is that ROWNUM is temporary while ROWID is permanent

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  


What is stored procedures?

0 Answers  


How to configure and test odbc dsn settings?

0 Answers  


What do you understand by a view? What does the with check option clause for a view do?

0 Answers  


Does view occupy space?

0 Answers  


What is cte (common table expression)?

0 Answers  


Explain some DBCC commands?

6 Answers  


What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,


How do clustered indexes store data?

0 Answers  


Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,


What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,


What are cursors in ms sql server?

0 Answers  


Categories