Purpose:To replace substring from a specified position to a specified position....

Purpose:To replace substring from a specified position to a specified position. Syntax:Overlay(string placing string from int [for int]) Example Select Overlay('www.beyondnational.com' Placing 'relational' From 11 For 8) "Overlay Example" /* Resul...

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"...

Purpose: This values helps to concatenate the input values into a string, separated by delimiter. We can pass any delimiter in this function...

Aim: A query to show which employees works for which department Option 1: Using String_Agg function Purpose: This values helps to concatenate the input values into a string, separated by delimiter. We can pass any delimiter in this function Syntax: S...

I don't have mysql installed in my system but you can try this SELECT id FROM emp ORDER BY id DESC LIMIT n,1 Also please have a look [at this url][1] hope all this will help you [1]: http://www.geekinterview.com/question_details/25...

In PostgreSQL concatenation can be done in the following ways...

In PostgreSQL concatenation can be done in the following ways Using Concatenation Operator ( || ) Using Concat function Using TextCat function Option 1: Using Concatenation Operator ( || ) Select 'Mr ' || EmpName "Employee Name"...

Writing Dynamic SQL Queries in PL/SQL using Native Dynamic SQL(NDS). If we need to build and execute SQL statements at runtime , we need to go for Dymanic SQL. In this article we will look into how to do so using NDS which has ...

Writing Dynamic SQL Queries in PL/SQL using Native Dynamic SQL(NDS) If we need to build and execute SQL statements at runtime , we need to go for Dymanic SQL. In this article we will look into how to do so using NDS which has two constructs Execu...