I am dealing with getting the output of some common values. My database is quite big so I am just giving a dummy database here for understanding purposes. Here is the table I have: I have to extract only those variables that have the given common room numbers alotted. This is the table for the required data: …
Tag: sql
How can I run this SELECT query?
I’m working on a Messaging feature for an application, and I have a the following tables in MSSQL, along with a User table (not listed): I want to query the ThreadParticipant table for whether or not a thread exists containing only a given set of user ids, let’s say users 1,3,5,7. Each Thread cont…
Show the names of customers that have accounts SQL Query Oracle 10G
Q1 Show the names of customers that have accounts Q2 Show the customer names with the names of the employees they deal with** Answer Q1 is a simple lookup of the cust_id in junction table has: This phrases as: select the customers that have at least one entry in the has table. When it comes to Q2: your data s…
SQL Date Range Specification, Explicit vs BETWEEN()
My understanding of SQL is that is the same as But I’m getting completely different ResultSets when the only difference in the queries is the date range specification. The correct dates are being returned but the data is different. This is happening in both Teradata and HANA. Am I missing something? EDI…
Laravel Eloquent Join Using Another table
Hi how to convert this SQL query to Laravel Eloquent? I have three table: payments, devices and users. Payments table does not store user_id. but table has device_id. And device table also has user_id. I want to get user name which made payment. Answer it’s very easy Another way is: We have three models…
Find average SQL statement multiple tables
Trying to get the average with a amount of times a user has purchases brocolli and then with the price at that time. A 0 if the user has not purchased any. This is working and saying it can’t see the Name column. What am I missing? EDIT I also tried simplifying to just use the purchasers table and get
Character with Bit/hex confusion in DB2
This works: SELECT TASKT_ID FROM DATA . TASKT WHERE TASK_WEB_IDENTIFIER = CAST ( HEXTORAW ( ‘0213725501A421D384233E5001’ ) AS CHAR ( 26 ) ) ; Since that work I put it into the procedure: BEGIN …
SQL Query String Works in SQL Server Management Studio, But Not in VB.net with SQLCommand.ExecuteReader
I have an ASPX page using VB.net code, and it is set up to run a series of SQL queries and populate a SQLDataReader with the results. Each SQL query is pulled from a specific field in a table within the SQL database. This code works perfectly for literally every query I run through it, except one. The VB code
How to I create a new column in a table and add values to it
I have to create a new column in my table called Raise that has a 20% raise from the values of the SAL column, here’s what I have so far: SELECT ENAME,EMPNO, JOB, SAL from emp ALTER TABLE emp ADD …
How to avoid rails as_json creating flood of database requests
I have a model questions that has many tags through another model question_tags. I am trying to write an api endpoint that returns a list of questions and for each question a list of it’s related tag’s name and id. I’m currently using; But this runs a separate db request for every question i…