How to Create a Pivot Table This Excel tutorial explains how to create a pivot table in Excel 2016 (with screenshots and step-by-step instructions). What is a Pivot Table? A pivot table is a tool that allows you to quickly summarize and analyze data in your spreadsheet. You can use a pivot table when: You […]
SQL
sql cheat sheet sql cheat sheet pdf sql show tables sql rollup sql limit offset sql list tables sql syntax cheat sheet sql query to list all tables in a database sql cube sql cheatsheet sql show all tables sql server cheat sheet sql list all tables no duplicates sql sql no duplicates sql triggers […]
Difference between Primary Key and Foreign Key
A primary key is used to ensure data in the specific column is unique. It is a column that cannot have NULL values. It is either an existing table column or a column that is specifically generated by the database according to a defined sequence. What is Primary key: Example: Refer to the image above:STUD_NO, as […]
Free SQL Online Editor
You can run SQL Query from the below SQL Editor without downloading it on your system. Embedding an online compiler into a website
SQL ORDER BY
Summary: This tutorial shows you how to use the SQL ORDER BY clause to sort the result set based on specified criteria in ascending or descending orders. Introduction to SQL ORDER BY clause When you use the SELECT statement to query data from a table, the order which rows appear in the result set may not be what you expected. In […]
How to Install Anaconda for Windows
Are you a data geek? Want to know how to install Anaconda for windows. Also want to write your first python or R code with the best distribution platform which arranges code for both. So I am here with this blog, we will learn about the complete Anaconda setup method (Download and Install Anaconda Python) […]