Category Archives: SQL SERVER/ORACLE

What is normalization? Explain different levels of normalization? Check out the article Q100139 from Microsoft knowledge base and of course, there’s much more information available in the net. It’ll be a good idea to get a hold of any RDBMS fundamentals text book, especially the one by C. J. Date. Most of the times, it [...]

Introduction: In this article,i am going to explain about how to add a rownum into an a select result query. Main: we can simply add a rownum into a select result query,see the below simple examble, SELECT ROW_NUMBER() OVER (ORDER BY FieldName ASC) AS ROWNO, * FROM Emp //Emp is a table name. Conclusion: Hope [...]