Questions tagged [querying]
516 questions
-1
votes
1 answer
Showing an Employee Profile in MySQL
Query:
SELECT DISTINCT Employee_Name, Employee_Type, Email, Birth_Date,
Previous_Education, Project_Name, Skill_Title
FROM Employee_T, Project_T, Skill_T, Skill_Overview_T
WHERE Employee_T.Employee_ID = Skill_T.Employee_ID
AND…
-1
votes
1 answer
MYSQL basic conditional aggregation for same Columns
i have the following issue and i don't know how can i achieve that.
I need to filter based on both conditions + same property
Get Users where the event is "paymentFailed" and event is not "paymentSuccess"
Basically i need to filter all "Failed…
Yoshio H Palacios
- 41
- 5
-1
votes
1 answer
How to perform FULL JOIN, LEFT JOIN and RIGHT JOIN in PostgreSQL
I am new to PostgreSQL. We have given an activity to perform FULL JOIN, LEFT JOIN, AND RIGHT JOIN. I have an answer but I am not sure if it is right. I need some help to correct me.
These are the questions and my answers.
Perform a FULL JOIN on…
Lorai
- 11
- 2
-1
votes
1 answer
infer byte size of JSON file stored in cassandra column for each row
I'm querying a vendor's cassandra database to fetch data from a table. The data returned is a JSON file stored as text. I want to determine the average size of the json file in the cassandra table.
Also other stats like max size and min size for…
-1
votes
2 answers
Incorrect parameter count in the call to native function 'DATE_FORMAT'
Not sure how to fix this error
Incorrect parameter count in the call to native function 'DATE_FORMAT'
Code:
SELECT
id, user_id, client_name, client_phone,
(SELECT name
FROM users_permissions
WHERE users_permissions.user_id =…
Bar12345
- 13
- 1
- 7
-1
votes
1 answer
Find Substring - SQL
I need to find a substring that is in a text field that is actually partially xml. I tried converting it to xml and then use the .value method but to no avail.
The element(substring) I am looking for is a method name that looks like…
PickyTech
- 135
- 3
- 9
-1
votes
1 answer
Rails/SQL help: three tables, select and sort by presence of another record
Using the ActsAsTaggableOn gem, taggable object is Template.
Plus these associations:
class Template
acts_as_taggable
has_many :template_designs
end
class Pins
belongs_to :template
belongs_to :tag
end
class Tags
has_many…
bazfer
- 23
- 8
-1
votes
2 answers
Querying SQL Server table with different values in same column with same ID
I have an SQL Server 2012 table with ID, First Name and Last name. The ID is unique per person but due to an error in the historical feed, different people were assigned the same id.
------------------------------
ID FirstName …
Vibhav MS
- 143
- 1
- 6
- 18
-1
votes
2 answers
Querying SQL table with different values in same column with same ID
I have an SQL Server 2012 table with ID, First Name and Last name. The ID is unique per person but due to an error in the historical feed, different people were assigned the same id.
------------------------------
ID FirstName …
Vibhav MS
- 143
- 1
- 6
- 18
-1
votes
1 answer
SQL Selecting rows from two tables where values are different including nulls
I've read a few other posts but haven't been able to find my answer. I have two tables that I'm linking (A & B). What I'm trying to do is get all the rows where my column value is different.
I know I need an OUTER JOIN in order to retrieve these…
Brandon
- 3,074
- 3
- 27
- 44
-1
votes
2 answers
Explanation of Simple SQL Query
I have a question on how the less than operator is used in this SQL query that answers the following English statement:
Drinkers who frequent at least two bars
NOTE: there is a table called frequents with columns of drinker and bar.
Now, I solved…
Chad
- 185
- 1
- 11
-1
votes
1 answer
Querying 2 Tables In SQL
I am trying to query this statement:
Drinkers who frequent all bars
Now I have a table called bars with a column of the names of every bar.
I also have a table called frequents with the name of the drinker and which bars they frequent.
With one…
Bret
- 167
- 1
- 1
- 12
-1
votes
1 answer
MySql Select where row count is 2
I have a table called frequents with 2 columns, drinkers and the bars they frequent.
I currently have answered this statement:
Drinkers who frequent at least 2 bars
With the following query:
SELECT DISTINCT drinker
FROM frequents f
WHERE…
Bret
- 167
- 1
- 1
- 12
-1
votes
1 answer
Q: Looking for name of technique or specific software for easy search and filtering on databases
I am looking for the name or specific software for easy search and filtering on databases.
So for example i have a huge database. I want to point an application to it and that this application is smart enough to make automatic search options (based…
Richard Duinmaijer
- 59
- 5
-1
votes
1 answer
How do I find an object whose properties foo or bar equal a query value?
I searched google and looked at the docs, but I found no example of this.
I have this object with embedded children:
{
teacher: "Balthazar",
students: [
{ name: 'Wilfred', sibling: 'Cordelia' },
{ name: 'Mortimer', sibling: 'Arthur' },
…
Jumbalaya Wanton
- 1,601
- 1
- 25
- 47