Since you have two columns that you now want to PIVOT, you’ll first have to unpivot those columns and then convert those values into the new columns. Starting in SQL Server 2005, you could use CROSS APPLY to unpivot the columns. The basic syntax will be similar to: select name, new_col, total from ( select … Read more
Oracle 10g2? Wow that’s kind of oldish, but here it is: Install libaio1 library: sudo apt-get update; sudo apt-get install -y libaio1 bc Download [from Oracle] and install the oracle database package. Make sure you get the correct architecture (takes around 3 minutes on a slow machine): sudo dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb Configure Oracle [change password … Read more
Try This , Create another table like this CREATE TABLE [dbo].[Table_1]( [Col2] [nvarchar](50) NULL, [CaseVal] [nchar](10) NULL ) ON [PRIMARY] Insert all the Distinct data what you have. Then write a sql like below SELECT b.Col1, b.Col2, a.CaseVal TargetAliasColumnName FROM Table_1 a inner join [dbo].[Table1] b on a.col2=b.Col2 1 solved SQL server SELECT CASE large … Read more
The security flaw would — conceivably — arise if user input is put directly into the table without validation and users are limited to what they can see. That is, if ‘%’ could allow someone to see data they shouldn’t. However, using a column name for the like pattern is not a SQL injection risk, … Read more
You can achieve it like following. SELECT ‘8=’ + CAST([8_length] AS VARCHAR(10)) AS [8_length] FROM [Your_Table] Note: If the column type is already VARCHAR, in that case you don’t need to use CAST solved I want to fetch data from table and append column name code to the value as key value pair. How to … Read more
Here is a way, demo at SQL Fiddle CREATE TABLE Table1 (“id” int, “datetime” time, “name” varchar(1)) ; INSERT INTO Table1 (“id”, “datetime”, “name”) VALUES (1, ’11:10:01′, ‘A’), (1, ’11:10:02′, ‘A’), (1, ’11:10:05′, ‘B’), (1, ’11:12:02′, ‘A’), (1, ’11:12:10′, ‘A’), (2, ’11:13:02′, ‘B’), (2, ’11:13:06′, ‘A’), (1, ’11:14:01′, ‘A’), (1, ’11:14:02′, ‘B’), (1, ’11:14:05′, ‘A’) … Read more
You are creating a new MarkerCluster every time you create a marker. Create it once, add all the markers to the same MarkerClusterer object. function initMap() { var map = new google.maps.Map(document.getElementById(‘map’), { center: new google.maps.LatLng(43.6191, -113.9772), zoom: 8 }); var infoWindow = new google.maps.InfoWindow; // ******************************************************************************** // ** move the markers array and the … Read more
Adjust your syntax to: SELECT tableA.something FROM tableA LEFT JOIN table on tableA.name = substr(table.title, LENGTH(table.title)-8) table.title is an argument to the LENGTH() function. Also needs to be argument to SUBSTR(). 4 solved oracle sql about table.substr
try this : select ID, count([Match ID]) as [TotalMatch ID] from ( SELECT TblMatch.CustomerID1 as ID, TblMatch.[Match ID] FROM TblMatch UNION ALL SELECT TblMatch.CustomerID2 as ID, TblMatch.[Match ID] FROM TblMatch ) tmp group by ID 0 solved SQL Union with group by and sum
Use CHAR_INDEX twice: SELECT *, SUBSTRING(path, pos1 + 1, pos2 – pos1 – 1) FROM tests CROSS APPLY (SELECT NULLIF(CHARINDEX(‘\’, path), 0)) AS ca1(pos1) CROSS APPLY (SELECT NULLIF(CHARINDEX(‘\’, path, pos1 + 1), 0)) AS ca2(pos2) — NULLIF is used to convert 0 value (character not found) to NULL Test on db<>fiddle 1 solved How to … Read more
you can try pivot. in my example here i have concatenated part and location together because i have no idea how to do this with two columns. the point that this is not good style remains, but maybe this helps you out a little. i named your table ttt in my example: select ‘serialno’ as … Read more
You are building the point and the polygon – instead of having proper geometry column – which is inefficient. You haven’t talked about spatial index, so the intersect operation will be slow. You haven’t specified the complexity of the polygons: if they have many many vertices, an intersect operation will be slow. This can be … Read more
Unless there’s more to the picture, why not just query everything, ordered by section, to have the A-Z: SELECT * FROM Main_Section ORDER BY section … and then process the results with one loop, which could look something like this: $sections = $connect->query(“SELECT * FROM Main_Section ORDER BY section”); while ($row = $sections->fetch_array()) { echo … Read more
Four are needed. It is as simple as laying five balls out in a straight line and counting the gaps between them. Unless you are willing to put all of your data into one great big mess of a table, in which case you could use a CROSS JOIN. 0 solved to join 5 tables … Read more
You have to concatenate the two fields, and pass them together to the group by as following select id, concat(`field1`,`field2`) as `together` from table_name group by together 1 solved how to select duplicate record as one record in mysql