Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To select first 10 elements from a database using SQL ORDER BY clause with LIMIT 10.The syntax is as followsSELECT *FROM yourTableName ORDER BY yourIdColumnName LIMIT 10;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table Clients - > ( - > Client_Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, - > ClientName varchar(20) - > ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using INSERT command.The query is as followsmysql> insert into Clients(ClientName) values('Larry'); Query OK, 1 row affected (0.09 ... Read More
JSON or JavaScript Object Notation is a lightweight text-based open standard designed for human-readable data interchange. Conventions used by JSON are known to programmers, which include C, C++, Java, Python, Perl, etc.There are several Java libraries available to handle JSON objects. Jackson is a simple java based library to serialize java objects to JSON and vice versa.Converting Java object to JSONThe ObjectMapper class of the Jackson API in Java provides methods to convert a Java object to JSON object and vice versa.The writeValueAsString() method of this class accepts a JSON object as a parameter and returns its respective JSON StringTherefore, ... Read More
Excel is a robust spreadsheet programme that provides a wealth of functions to aid in the efficient organisation and analysis of your data. The ability to mix text with cell values is one important feature that can be helpful for creating custom labels, adding prefixes or suffixes to existing data, or simply for formatting information. By the end of this session, you will know how to merge text and cell values in many situations effortlessly using basic formulas, Excel functions, and even more sophisticated methods. Let's get started and learn the methods that will enable you to enrich and manage ... Read More
Ever ponder whether you might easily incorporate video playback into your Excel spreadsheets? The good news is that it is in fact feasible, and in this lesson, we'll examine the detailed steps involved in carrying it out. Excel's ability to play videos can be beneficial for a number of tasks, including the creation of interactive presentations, training materials, or simply adding a visual component to your spreadsheet. You may embed a video file into your Excel worksheet and enable playback right within the spreadsheet by following the instructions in this article. This tutorial will provide you the skills and resources ... Read More
Your Excel workbooks can benefit from the interactive and dynamic addition of sound effects, which can notify you when certain circumstances or occurrences arise. Excel has robust options to complete this work, whether you want to make a sound notification for meeting deadlines, track changes, or simply add a little interactivity. This tutorial will show you how to use Excel to play a sound if certain conditions are met. Before we get started, it's crucial to understand that this course presupposes a basic understanding of Excel and its features. You should have Excel installed on your computer in order to ... Read More
There are several situations in Microsoft Excel when it may be necessary to compare two values and extract either the lower or higher value depending on particular conditions or requirements. Excel's robust functions and formulae let you easily do these comparisons whether you're working with numerical data, dates, or any other kind of information. This article will give you step-by-step instructions and examples to help you master the skill of determining the lower or greater value from a pair of cells, regardless of your level of expertise with Excel. You will have a firm grasp on how to perform these ... Read More
Errors and Error Correcting CodesWhen bits are transmitted over the computer network, they are subject to get corrupted due to interference and network problems. The corrupted bits leads to spurious data being received by the receiver and are called errors.Error-correcting codes (ECC) are a sequence of numbers generated by specific algorithms for detecting and removing errors in data that has been transmitted over noisy channels. Error correcting codes ascertain the exact number of bits that has been corrupted and the location of the corrupted bits, within the limitations in algorithm.ECCs can be broadly categorized into two types −Block codes − ... Read More
A deadlock happens in operating system when two or more processes need some resource to complete their execution that is held by the other process.A deadlock occurs if the four Coffman conditions hold true. But these conditions are not mutually exclusive. They are given as follows −Mutual ExclusionThere should be a resource that can only be held by one process at a time. In the diagram below, there is a single instance of Resource 1 and it is held by Process 1 only.Hold and WaitA process can hold multiple resources and still request more resources from other processes which are ... Read More
What is Partial Dependency?Partial Dependency occurs when a non-prime attribute is functionally dependent on part of a candidate key.The 2nd Normal Form (2NF) eliminates the Partial Dependency.Let us see an example −ExampleStudentIDProjectNoStudentNameProjectNameS01199KatieGeo LocationS02120OllieCluster ExplorationIn the above table, we have partial dependency; let us see how −The prime key attributes are StudentID and ProjectNo, andStudentID = Unique ID of the studentStudentName = Name of the studentProjectNo = Unique ID of the projectProjectName = Name of the projectAs stated, the non-prime attributes i.e. StudentName and ProjectName should be functionally dependent on part of a candidate key, to be Partial Dependent.The StudentName can be determined by StudentID, which makes the relation ... Read More
You may frequently find yourself in circumstances where you want to paste certain values without affecting the hidden or filtered cells when working with huge datasets or applying filters to your data. Fortunately, Excel has a straightforward yet effective capability to carry out this activity. This article will walk you through the step-by-step process of pasting values to cells that are visible or that have been filtered only. By doing this, you may update or modify your data while keeping the integrity of your data intact. Regardless of your level of Excel proficiency, this book will help you master the ... Read More