ItsMyCode
  • How To
  • Python
    • Basics
    • Advanced
    • Built-In Methods
    • Dictionary Methods
    • String Methods
    • List Methods
    • Date and Time
    • Files and Folders
    • Matplotlib
    • Seaborn
    • NumPy
    • Pandas
    • SciPy
    • Errors and Exception
    • Django
  • R
  • Git
  • Powershell
  • Javascript
  • C#
    • Sitecore
  • Node.js
ItsMyCode

Coding Simplified

  • How To
  • Python
    • Basics
    • Advanced
    • Built-In Methods
    • Dictionary Methods
    • String Methods
    • List Methods
    • Date and Time
    • Files and Folders
    • Matplotlib
    • Seaborn
    • NumPy
    • Pandas
    • SciPy
    • Errors and Exception
    • Django
  • R
  • Git
  • Powershell
  • Javascript
  • C#
    • Sitecore
  • Node.js
541
98
0

Home » SQL

Browsing Category

SQL

7 posts

SQL stands for Structured Query Language. SQL is a database computer language designed for the retrieval and management of data in a relational database.

Sql
  • How To
  • SQL
  • 1 minute read

How do I escape a single quote in SQL Server

  • Avatar Of Srinivas RamakrishnaSrinivas Ramakrishna
  • January 16, 2022
A single quote can be escaped by doubling them up in MSSQL server. There are many ways to escape a single quote in SQL server. Let us look at the…
View Post
Sql
  • How To
  • SQL
  • 1 minute read

How to Delete Duplicate Rows in sql

  • Avatar Of Srinivas RamakrishnaSrinivas Ramakrishna
  • August 25, 2021
There are many ways to identify and delete duplicate rows in SQL. The best way to achieve this would be by using the ROW_NUMBER over Partition by column list. This…
View Post
Sql
  • How To
  • SQL
  • 1 minute read

How to find nth highest salary using SQL query

  • Avatar Of Srinivas RamakrishnaSrinivas Ramakrishna
  • August 25, 2021
This is a common SQL question which will be asked in most of the interviews and also if you are working related to the financial application then most of them…
View Post
Sql
  • How To
  • SQL
  • 1 minute read

How to Include Null Values in JSON Output in MSSQL

  • Avatar Of Srinivas RamakrishnaSrinivas Ramakrishna
  • August 25, 2021
One of the top features of MSSQL server 2016 is built in support of JSON. The data from the MSSQL can be exported to JSON by adding the FOR JSON…
View Post
Sql
  • How To
  • SQL
  • 2 minute read

How to Format Query Results as JSON in MSSQL

  • Avatar Of Srinivas RamakrishnaSrinivas Ramakrishna
  • August 25, 2021
One of the top features of MSSQL server 2016 is built in support of JSON. Yes, now we can format query results as JSON in MSSQL 2016 version onwards. The…
View Post
Sql
  • How To
  • SQL
  • 1 minute read

How to add root node to JSON output in MSSQL?

  • Avatar Of Srinivas RamakrishnaSrinivas Ramakrishna
  • August 25, 2021
MSSQL 2016 has a new feature where you can return the data as JSON output format and also add root node to JSON output in MSSQL. Checkout MSSQL Built-In JSON…
View Post
Sql
  • How To
  • SQL
  • 2 minute read

How to find size of table in MSSQL?

  • Avatar Of Srinivas RamakrishnaSrinivas Ramakrishna
  • August 25, 2021
Everyone would have come across a scenario where there is a need to find the Size of the table in MSSQL. There are multiple ways to find size of table…
View Post
  • Metrics Converter
  • Sitemap
  • Privacy Policy
  • Cookie Policy
  • Contact Us
541
98
0
0
ItsMyCode
Copyright © 2022· All Rights Reserved