Lab Sql

I have this query: SELECT p.id, r.status, r.title FROM page AS p INNER JOIN page_revision as r … Read more Sql Query Performance Question (multiple Sub-queries)

I have a table (Meeting) with date type attribute (MeetDate) and another varchar2 type attribute (W… Read more Oracle To_char Subquery In Trigger

I have 3 tables ....users, updates and bumps. I want to return the user making the api request a fe… Read more Mysql Select Subquery If Exists

I have read the other questions and all of the posted comments/answers to questions that are simila… Read more Place An Insert Statement Into A Select Statement

I have three tables and want to: Select all students from the first table, that have at least on… Read more I Need An Jpa/sql Expert: Exists Query On An Inner Join Returns Wrong Result

I am trying to get the student that scored highest on the final exam first I select SELECT s.STUDE… Read more Subquery - Getting The Highest Score

I see many similar questions but they're either so complex I can't understand them, or they… Read more Use Results From One Sql Query In Another Where Statement (subquery?)

I'm using SQL Server 2014 and utilizing the AdventureWorks2012 sample database provided by Micr… Read more Delete Duplicate Rows Using Sub-query

I am trying to list unique user engagements with the engagement_type I used to have the following q… Read more How Do I Get Unique User Engagements?

My table structure looks similiar to this Customer_id Country item_type Order_Size Dates Co… Read more Alternative To Case When With Subqquery To Avoid Error (illegal Expression In When Clause Within Case Statement)

First let me point out that this is a repeat of multiple stack-overflow questions that all have ans… Read more How To Select Top 1 In Access Query - And Actually Get It To Work

I'm noticing something a bit unexpected with how SQL Server (SQL Server 2008 in this case) trea… Read more Impact Of Ordering Of Correlated Subqueries Within A Projection

Not sure the title accurately reflects what I need to do and this question is possibly out of the s… Read more Mysql Recursive Subquery

I have the following SQL which works: Select TRADING_DWKEY, M_SM_USER_CODE, FIRST_TRA… Read more Adding Inner Join To Query With Subquery With Inline Select Statement

What is happening here? I got two tables, test1 and test2: create table test1 (id1 int4 primary key… Read more Postgresql Subquery With Syntax Error Gives A Valid Result

I have a table, let's call it My_Table that has a Created datetime column (in SQL Server) that … Read more Error When Calculating A Running Total (cumulative Over The Previous Periods)

I have 2 columns in MS SQL one is Serial no. and other is values. I need the thrird column which gi… Read more Moving Average / Rolling Average

I am trying to retrieve the count of records between a certain date range that is specific to the u… Read more Sql Having Between A Date Range

My website contains pieces of content on which users can vote (like/dislike similar to reddit upvot… Read more Optimizing Mysql Query (likes/dislikes)

I have an update query that I need to run in MySQL and am having some trouble with it. I have spent… Read more Update With A Subquery In Mysql