Never use commas in the FROM clause. Always use proper, explicit JOIN syntax. Then, you cannot nest aggregation functions, so this should be sufficient: SELECT o.ID_DOSSIER, SUM(CASE WHEN ID_TYPE IN (‘0’, ‘1’) THEN TTL * -1 WHEN ID_TYPE IN (‘2’, ‘3’) THEN TTL END) FROM ope o JOIN actor a ON o.ID_ACTION = a.ID_ACTION GROUP … Read more
No need to make thinks more complicated than they need to be… IF OBJECT_ID(‘tempdb..#TestData’, ‘U’) IS NOT NULL DROP TABLE #TestData; CREATE TABLE #TestData ( ID INT NOT NULL, [Year] INT NOT NULL ); INSERT #TestData (ID, Year) VALUES (1, 2010), (1, 2010), (2, 2010), (2, 2011), (3, 2012), (4, 2013), (5, 2014), (5, 2014), … Read more
The solution I have in mind is to run the query with an AND for all the data that does have a pattern Well, if you want to find everything that doesn’t follow any pattern just enclose all the patterns within brackets and combine with boolean AND. Then just put a NOT outside the brackets. … Read more
Ever heard of JOINing tables? SELECT photo.id FROM product_photo INNER JOIN product_photo AS photo ON photo.product_id = product_photo.product_id AND photo.order >= product_photo.order WHERE product_photo.id = ’33’; The FROM and WHERE parts will select your product id = 33 and then you join product_photo with different alias (yes, you can join the same table multiple times … Read more
You basically have the answer written in your question already: IF (NOT EXISTS (SELECT * FROM names WHERE name = @name)) INSERT INTO names (name) values (@name); SELECT id FROM names WHERE name = @name; The only problem is that you haven’t set up your table names to use an IDENTITY column. This means you … Read more
For MS-ACCESS, DateADD should work. Try something like this: select name from babies where birthdate >= DATEADD(‘m’, -18, Date()) 2 solved How to subtract 18 months from the current date in MS-ACCESS [closed]
Use for this KeyDown event private void YourTextBox_KeyDown(object sender, KeyEventArgs e) { String connection= “Data Source=YourServer;Initial Catalog=YourDatabase;user=User;password=YourPassword;Integrated Security=True;”; if (e.KeyCode == Keys.Enter) { string insertCmdText = “INSERT INTO table(column1)values(@valueForColumn1)”; SqlCommand sqlCom = new SqlCommand(insertCmdText,connection); sqlCom.Paramaters.AddWithValue(“@valueForColumn1”,YourTextBox.Text); connection.Open(); sqlCom.ExecuteNonQuery(); connection.Close(); } } But consider that saving into Database after KeyPress event is not a right way to … Read more
You’re close! You need to use PATINDEX instead of CHARINDEX. After that, you can use SUBSTRING to pull the six numbers out. This should work for you: Select SUBSTRING(d.Notes, PATINDEX(‘%[0-9][0-9][0-9][0-9][0-9][0-9]%’, d.Notes), 6) From YourTable d If there are records in your table that do not have six consecutive numbers, you can use either of the … Read more
It seems that you are looking for a concat operator as below. SELECT cust_code, cust_name, address_1 + address_2 + address_3 + address_4, telephone FROM a_customer ORDER BY cust_name ASC; You can check the demo here 1 solved How to join 3 columns in SQL Server Management Studio?
I think you need to use a case statement for the value. Below is just off the top of my head, so you may need to use full join if that doesn’t work. select t1.date, case when t3.IDCLIENT is not NULL then t3.value else t2.value end as Value from Table1 t1 inner join Table2 t2 … Read more
If you just want to return the rows from each table that match, then you can use a UNION ALL: SELECT * FROM Table1 WHERE column2 = 1 union all SELECT * FROM Table2 WHERE column22= 1; See SQL Fiddle with Demo If you want to return the rows that match both criteria, then possibly … Read more
I’m assuming you want to communicate with the remote server through API.To Send POST and GET request to the server, means to create a connection between the server and Android Application.There are many libraries to make HTTP request for example Retrofit,Volley etc, These powerful libraries make it easy to consume JSON or XML data.You can … Read more
Since you didn’t specify which RDBMS you are working on and the table schema, then you can do this: SELECT t1.tenantId, t1.ExpiryDate FROM tenants AS t1 INNER JOIN ( SELECT tenantId, MAX(ExpiryDate) AS LatestExpiryDate FROM tablename GROUP BY tenantId ) AS t1 ON t1.tenantId = t2.tenantId, t1.ExpiryDate = t2.LatestExpiryDate; The inner join will give the … Read more
Try this SELECT Video_id,COUNT(Video_id) FROM tbl Group By Video_id FIDDLE DEMO O/P VIDEO_ID COUNT(VIDEO_ID) 1 3 2 2 4 4 Take a look at these document http://dev.mysql.com/doc/refman/5.1/en/counting-rows.html http://dev.mysql.com/doc/refman/5.1/en/group-by-extensions.html 0 solved SQL query to count numbers [closed]
There are several problems with Query 1. First, why does it have trailing ))? Either they shouldn’t be there, or there are some missing ( elsewhere. Second, the placement of the EXCEPT is wrong. The example is this… SELECT sname FROM … WHERE NOT EXISTS (…) EXCEPT SELECT bid FROM … But it appears that, … Read more