SQL Server Square

SQL Server Square

1 Square: 1 2 Square: 4 3 Square: 9 4 Square: 16 5 Square: 25 6 Square: 36 7 Square: 49 8 Square: 64 9 Square: 81 10 Square: 100 […]

Bootstrap Library System

Overview https://codepen.io/guldus/pen/YMWeLe Github: https://github.com/Furkan-Gulsen/Library-System HTML CSS(main) CSS( insertion_section ) CSS ( book list ) JavaScript

Golden – Bootstrap Webpage

Preview: Github:https://github.com/Furkan-Gulsen/Bootstrap-webpage/tree/master/Golden%20-%20OnePage%20Template HTML CSS JavaScript

SQL Insert Into

SQL Insert Into

There are many ways to add data to any table in Microsoft SQL. By opening a table in edit mode, you can manually add it to the relevant columns on […]

SQL FIRST_VALUE() and LAST_VALUE()

SQL FIRST_VALUE() and LAST_VALUE()

FIRST_VALUE (), one of our new analytic functions that comes with SQL Server 2012, returns the first value in the sorted data set. LAST_VALUE () returns the last value in […]

SQL LEAD and LAG()

SQL LEAD and LAG()

The “LEAD ()” function returns the next incoming value based on the specified offset value. If no such value exists, it returns “default”. Returns “NULL” if “default” is not entered […]

SQL RANK and DENSE_RANK

The functions RANK and DENSE_RANK are very similar to the ROW_NUMBER function. The difference is the ORDER_BY statement and the connections between these functions. The RANK function returns the same […]

SQL ROW_NUMBER

SQL ROW_NUMBER

Row_Number () is used to create a sort column in the record list that results from a sql query. In short, the rotating list is a function that creates line numbers for sorting. We can also group these line numbers by any field. This function comes with SQL 2005.

Bootstrap Sidebar Menu

Bootstrap Sidebar Menu

CODEPEN Github: https://github.com/Furkan-Gulsen/HTML-CSS-JAVASCRIPT/tree/master/Bootstrap%20Sidebar%20Menu HTML CSS(SASS) JavaScript

sql Grouping Sets

SQL Grouping Sets

What is the Grouping sets statement on sql server? What is the difference with Union? In our queries that contain the Sum function, we combine different grouping schemes using the […]

SQL Cube and Rollup

SQL Cube and Rollup

We can use CUBE and ROLLUP statements together with the GROUP BY statement to create sub-aggregations in our queries that contain the aggregate function. CUBE and ROLLUP are very similar, […]