Learn

Summary: this tutorial introduces you to the basic of the SQL Server SELECT statement, focusing on how to query against a single table. Basic SQL Server SELECT statement Database tables are objects that stores all the data in a database. In a table, data is logically organized in a row-and-column format which is similar to a spreadsheet. In a table, each row represents a unique record and each column represents a field in the...

Read More

Learn

Section 1. Querying data This section helps you learn how to query data from the SQL Server database. We will start with a simple query that allows you to retrieve data from a single table. SELECT – show you how to query data against a single table. Section 2. Sorting data ORDER BY – sort the result set based on values in a specified list of columns Section 3. Limiting rows OFFSET FETCH – limit the number of rows returned by a query. SELECT TOP – limit the number of rows or percentage of rows returned in a query’s result...

Read More

Learn

Summary: in this tutorial, you will learn how to delete duplicate rows from a table in SQL Server. To delete the duplicate rows from the table in SQL Server, you follow these steps: Find duplicate rows using GROUP BY clause or ROW_NUMBER() function. Use DELETE statement to remove the duplicate rows. Let’s set up a sample table for the demonstration. Setting up a sample table First, create a new table named sales.contacts as...

Read More

Learn

Architecture of React Native Pre-Requisites 1. Hardware requirements RAM: 8 GB (If you are going to use the emulator on your machine). 2. Software requirements Software Version Android studio (IDE) 2.2.3 Android Sdk 25.0.2 Java 1.8.0_121 Node Js 4.2.6 NPM 3.5.2 React native cli 2.0.1 React Native setup for Windows First, you’ll need to install the node on your machine. If you already have node js skip the node installation steps,...

Read More