I have a simple table with data as As we can see that row 1 & 2 contains exact same ColumnA, ColumnB & ColumnC. I want to form a simple select that can ignore the ‘N’ values where we already …
update command C# DataGridView to SQL
I’m attempting to update a SQL table from C# project datagridview “Work_Table”. However when I attempt to make the update I get this error “Update unable to find TableMapping [‘…
Group by a few columns including MAX() to limit rows but display columns not in group by
I’m outputting sp_whoisactive to a log table every 5 minutes and want to aggregate columns such as elapsed time or cpu. My best chance for unique record is session_id, login_time, login_name and I …
Will ON DELETE CASCADE delete a parent even if another child has it as parent?
This is a question about the behavior of MySQL (I have version 8.0.18 for what it’s worth) when you delete a row in a table that was created with a DELETE ON CASCADE clause. Suppose I have these 2 …
How to deal with Dynamic Queries
Simple Question I have a table that looks like this I am looking to do is do a select so I can get a result as Is this a PIVOTING issue? looking for suggestions to see how I can form a ‘Select’ …
Calling Procedure with ‘call’ function from within P/L SQL Script Oracle
I am not able to run this simple if/then statement in oracle database. (i think it is 10.x but not sure, seems to be an issue of my sql skill not db version). Can you help me figure out how to run …
Count by Self Joining same table where one field is empty but another has value
I have a table that contains two sets of GPS coordinates, ones supplied by the customers the other captured by our field device. The table’s name is customer, the field names are as follows: ID …
presto replace multiple characters
I have a string and would like to remove a set of characters. Is there a better way than chaining multiple replace()? I came up with the following but it requires a replace() call for each character: This is a minimal example and I have more characters to escape so I was looking for a less verbose way of achi…
How to implement LIKE functionality in a grouped query that depends on an IN operator? [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question After some great interaction here in Stack Overflow I am able to implement queries to get al…
How do I Count the words in a string using regex
I’m trying to count the words in a string using regex in Oracle 10g. I’ve been trying this select * from books where REGEXP_LIKE(title, ‘[ ]{2}’); so that its returning titles with at least 3 words …