whats wrong about this code ? I am trying to display all data on Employee_ID & Salary column, nothing else. what am I doing wrong here ? Answer Is this what you want?
Tag: sql
Two dimensional comparison in sql
DB schema There are rows with the same cryptid, I need to squash them to one row. So the cryptid becomes effectively unique. The complexity comes from the fact that I need to compare dates by rows as well as by columns. How to implement that? The rule I need to use is: status should be taken from the row
Select first and nth order for each client
I’m trying to display first and fifth order_id for each user. Table looks like this: I wrote something like this: But I want to see clients who made their first orders but don’t have fifths. There should be NULL, but I can’t understand how to make it. :c Answer Put the where t2.rn = 5 condit…
Why am I getting a duplicated column when doing this SQL query?
I am trying to do a set of queries in mySQL. In my final query I am trying to select the course_id column, but there are two columns with the title course_id and the exact same values, so I am encountering an error saying Query Error: Error: ER_NON_UNIQ_ERROR: Column ‘course_id’ in field list is a…
How can I use an SQL query’s result for the WHERE clause of another query?
Okay, basically I have a table that contains statements like: I would like to use the contents from this table to generate other tables that fulfill the conditions expressed in this one. So I would need to make it something like But the last part of the where has to come from the first table. Right now what I…
Joining table which may not exist with where clause
I have two tables. Let’s say they are: I’d like to make a join to get customer name, number of orders which he/she has finished and sum of money which he/she has spent in total So I’m making this SQL query: If a customer has any finished orders then it will get everything right. But if there…
SQL – Merge two rows with similar values
I have the following table called areas in a PostgreSQL server: So basically it’s nearly duplicate entries that have the same name and code, but different id, shape and created timestamp. What I want is to merge those duplicate rows, but overwrite the “shape” and “created” fields…
SQL Server : calculate column value based on value in previous row/id
I have what I hope is a simple problem to solve, but one that is puzzling me. My table can be created with the below sql: Which looks like this: This is basically a currency conversion task (the costs in the es-mx row are arbitrary in this example). What I wish to do is update all the TotalProjectCost values …
MariaDb InnoDB deadlock while doing many inserts
I’m having deadlock issues with a MariaDB (10.0.27)if it’s under pressure. The database schema is basically a hierarchy and the leaf node causes this: This is how my leaf table looks like: I’m able to reproduce the deadlock with an input set that puts the system under pressure. With this, I&…
Joining back on the same table in SQL server
I have a table like below And the output I require is The match is defined on the basis of PO number. If PO number exists in both the sources then it should be match else only in AAP and only in SNW respectively. Can this be achieved? Thanks, Ani Answer or