Order by is a clause in SQL. It is used to sort the result set of a query in either ascending or descending order. It can sort using one or more columns. In this article, we will discuss the Order by clause in MS SQL Server. Syntax The syntax for using the Order by clause in MS SQL Server is as follows − SELECT column1, column2, ... FROM table_name ORDER BY column1 [ASC|DESC], column2 [ASC|DESC], ...; Explanation of Syntax SELECT column1, column2, ... : Specifies the columns that we want to retrieve from the table. FROM table_name: Specifies ... Read More

DBMS supports object-oriented data. It ensures direct correspondence between real-world objects and their representations in the database. This correspondence ensures that objects retain their integrity and identity. It enables easy identification and manipulation. Object Data Management System (ODMS) assigns unique identity to each independent object stored in the database. This unique identity is implemented through a system-generated object identifier (OID). This OID serves as distinct value assigned to each object by the system. It is not visible to external users. However it is internally utilized by the system to ensure the unique identification of each object and to establish and ... Read More

MySQL Recursive CTE allows users to write queries that involve recursive operations. Recursive CTE is an expression that is defined recursively. It is useful in hierarchical data, graph traversals, data aggregation, and data reporting. In this article, we will discuss Recursive CTE with its syntax and examples. Introduction Common Table Expression (CTE) is a way to give a name to the temporary result sets generated by each query in MySQL. The WITH clause is used to define a CTE, and multiple CTEs can be defined in a single statement using this clause. However, a CTE can only reference other CTEs ... Read More

When we work with data in MS SQL Server, we often need to perform calculations or filter results based on data type. Properly converting data types ensures that our calculations are accurate and our queries return the desired results. In this article, we will discuss various type conversions in MS SQL Server. Built-in Data Types in MS SQL Server MS SQL Server has various built-in data types to store different types of data. These are the common built-in data types in MS SQL Server − int: Used to store integers. decimal: Used to store decimal numbers. varchar: Used to ... Read More

Partition By clause can be used to improve query performance. It reduces storage requirements, and improves data manageability. By partitioning a large table, queries that access only a small subset of the data can be executed more quickly. Partitioning can also improve backup and restore times. In this article, we will discuss the Partition By clause in MySQL with syntax and various examples. Introduction The purpose of a PARTITION BY clause is to group rows of a table into separate partitions. This is particularly helpful when performing calculations on specific rows within a partition using other rows from the same ... Read More

In this article, we will discuss about: minute(), microsecond(), and hour() MySQL functions. We will do these with the help of their syntax, usage and use cases. MySQL is an open-source relational DBMS. It allows users to store and manipulate data. In MySQL, we can perform specific tasks using functions. MINUTE() function The MINUTE() function returns the minute portion of a given time or datetime value. It takes one argument, which is the time or datetime value to extract the minutes. Output format Output range is 0 to 59 as integer value. Syntax The syntax of the MINUTE() function is ... Read More

MySQL is a popular open-source database management system that is widely used by businesses, organizations, and developers. It is known for its reliability, scalability, and ease of use. If you are running a Windows Server, you may want to install and configure MySQL to store and manage your data efficiently. In this article, we will guide you through process of installing and configuring MySQL on a Windows Server. Step 1: Download MySQL Installer The first step in installing MySQL on a Windows Server is to download MySQL Installer from official MySQL website. installer is a graphical tool that makes it ... Read More

Introduction One of the main objectives of any company is to look after the advancement of their services. For instance, Google Cloud is a widely known cloud service provider, and its services include SQL server engine, MYSQL, and PostgreSQL. Databases take too long to complete tasks such as patching OS systems. With the help of Google Databases, the backup configuration is also possible with the additional benefit of having security. It helps new businesses to build their product as per the business requirements. One of the most common queries a cloud database service provider gets is the ... Read More

As a database administrator, you need to be well-versed in MySQL, one of the most popular open-source database management systems. Whether you are a beginner or an experienced professional, there are some basic MySQL interview questions that you should be prepared to answer. In this article, we'll cover some of the most common questions and provide examples to help you prepare for your next interview. What is MySQL? MySQL is an open-source relational database management system (RDBMS) that uses SQL (Structured Query Language) to manage and manipulate data. It was first released in 1995 and is currently owned by Oracle ... Read More

Introduction MySQL is one of most widely used open-source relational database management systems (RDBMS) in world. It is used by some of largest companies in world, including Google, Facebook, and Twitter. If you are preparing for an interview for a MySQL developer position, you need to be well-prepared with advance MySQL database interview questions and answers. In this article, we will cover some of most common and advanced MySQL database interview questions and provide you with best possible answers. What is MySQL? MySQL is an open-source relational database management system. It is widely used by developers to store and manage ... Read More