SQL Tutorial
Microsoft® SQL Server® 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data integration, analysis, and reporting solutions.
Microsoft® SQL Server® 2008 provides a trusted, productive, and intelligent data platform that enables you to run your most demanding mission-critical applications, [...]
Continue reading about An Introduction to Microsoft SQL Server 2008 – Part 1
The difference between RANK() and DENSE_RANK() is that RANK() leaves gaps in the ranking sequence when there are ties. Let us see this function through an example.
Continue reading about SQL Tutorial : Using RANK() and DENSE_RANK()
In this tutorial we can see how to convert rows into columns using Structured Query language SQL. We cover this tutorial from the basic steps i.e creating tables and inserting values into the table so that it can be useful for basic users as well
Continue reading about SQL Tutorial : Converting Rows to Columns
