Tutorialspoint.dev
Welcome To Tutorialspoint.dev
Officially launched 18th May 2019
CSS HTML Web Technologies

CSS media queries

Media query is used to create responsive web design. It means that the view of web page differ from system to system based on screen or media types. Media queries can...
Advanced Computer Subject SQL secure-coding

Mitigation of SQL Injection Attack using Prepared Statements (Parameterized Queries)

As explained in this article, an SQL Injection attack, or an SQLi, is a way of exploiting the underlying vulnerability of an SQL statement by inserting nefarious SQL ...
SQL SQL

SQL Sub queries in From Clause

From clause can be used to specify a sub-query expression in SQL. The relation produced by the sub-query is then used as a new relation on which the outer query is a...
SQL SQL

SQL Correlated Subqueries

Correlated subqueries are used for row-by-row processing. Each subquery is executed once for every row of the outer query. A correlated subquery is evaluated once for...
SQL Technical Scripter SQL

SQL Top-N Queries

Top-N Analysis in SQL deals with How to limit the number of rows returned from ordered sets of data in SQL. Top-N queries ask for the n smallest or largest values of ...
SQL SQL

SQL SUB Queries

In SQL a Subquery can be simply defined as a query within another query. In other words we can say that a Subquery is a query that is embedded in WHERE clause of anot...
DBMS DBMS-SQL DBMS

DBMS Nested Queries in SQL

Prerequisites : Basics of SQL   In nested queries, a query is written inside a query. The result of inner query is used in execution of outer query. We will use ...
Advanced Computer Subject SQL secure-coding

Mitigation of SQL Injection Attack using Prepared Statements (Parameterized Queries)

As explained in this article, an SQL Injection attack, or an SQLi, is a way of exploiting the underlying vulnerability of an SQL statement by inserting nefarious SQL ...
DBMS SQL DBMS Indexing

SQL queries on clustered and non-clustered Indexes

Prerequisite – Indexing in Databases Indexing is a procedure that returns your requested data faster from the defined table. Without indexing, the SQL server h...
Geometric Binary Search Geometric

Queries on count of points lie inside a circle

Given n coordinate (x, y) of points on 2D plane and Q queries. Each query contains an integer r, the task is to count the number of points lying inside or on the circ...

Subscribe to Our Newsletter