Tags » SQL

Convert multiple rows into one with comma as separator


If I issue SELECT username FROM Users I get this result:


but what I really need is one row with all the values separated by comma, like this: 82 more words

SQL Server

Hiring Core Java Developer@Madhees

Madhees hiring Senior Core Java Developer having 3+ Years of Experience in Java and J2EE  for one of our esteemed client, Expertise in Telecommunications and IT, Incorporate its development center in Bangalore, India. 190 more words

Job Postiongs

Chunking tables 8: second solution

Here is the second complete solution to the problem of dividing a table into chunks of equal size. This is the solution whose first version was marked “correct” on OTN. 1,155 more words


MySql query execution flow

To optimize the query its import to understand the execution flow of query, here is an example:

SELECT product, SUM(quantity) AS "Total quantity"
FROM order_details
JOIN orders on orders.id = order_details.id
WHERE order_details.type = 'automobile'
GROUP BY product
HAVING SUM(quantity) > 10
ORDER BY order_details.id DESC;

In the above query we will have flow like

1. 230 more words

SQL SERVER - 2016: Creating Simple Temporal Table

Temporal tables are a new feature that was introduced in SQL Server 2016. Temporal tables give application developers to view the state of data at a point in time. 402 more words

SQL Authority

Optimize mysql using mysqltuner.pl

Install MySQLTuner

To identify the MySQL version on your database server, run this command: 1,798 more words


Use View to facilitate stack rows within table

In SQL, if you want to aggregate several relevant rows of a table into 1 and then select some of them. Creating a View using SQL can be used to considered as a temporary table which is updated dynamically as the change of the original table.

Data Manipulation