All Questions
11 questions
0
votes
1
answer
38
views
MIN Date within a single row
I am working on a query to provide the # of days a hiring process takes to complete. The process starts with a release being provided by the candidate (Release Accepted) and ends with either a Final ...
- 1
0
votes
1
answer
684
views
How can I get the earliest date to display using the MIN function in MS Access
I am in an intro to databases class. I have to list the earliest contact date of an employee along with their contactID and contactType. The code I have that gives me the earliest date is:
SELECT MIN (...
- 1
2
votes
1
answer
486
views
How select the min between a SQL value and a fixed number
I have to run this query in SQL that will return the min between a fixed scalar (let's say 7) and the value in the column. I tried:
SELECT from theTable min(theTable.Column , 7) AS Label
I get an ...
- 484
2
votes
2
answers
80
views
Returning the Min() of a Count()
I am studying for an SQL test and the previous year has the final question:
Name the student who has studied the least number of papers. How many
papers have they studied?
So far, this is the ...
- 607
0
votes
1
answer
777
views
Show other field(s) associated with record retrieved with Access query MIN() function
I am using the following query:
SELECT [ActionItems].AutoID, Min([ActionItems].[Action Status]) AS [MinOfAction Status]
FROM [ActionItems]
GROUP BY [ActionItems].AutoID;
I have a custom sort set ...
user4734199
0
votes
1
answer
58
views
Trying to Get the Earliest Date using MIN()
SELECT ID, AppID, Description, Min([Transaction Date]) AS 'Transacton Date'
FROM AppProsHist
WHERE [Description]='Non-Final Rejection'
GROUP BY ID, AppID, Description
I thought this would allow for ...
- 118
0
votes
1
answer
643
views
In Access,get the Max time and min time using sql
My table just like this,I want to get the Maxtime and the Mintime, when the user-id is A or B.
user_id time
---------- ----------
A 2016-01-03 23:02:35
A 2016-01-03 23:...
- 11
1
vote
1
answer
113
views
Display lowest cost of an item over various databases using only part number and cost
I have 3 databases (actual query seperated below) that I have union queried together. I am trying to get the lowest cost among the 3 based upon one MFG PART NO.
The one common is the MFG PART NO so I ...
- 11
0
votes
0
answers
358
views
SQL: Display associated value based on Min and Max values
I have tblDump which has ~52,000 records. It is a list of IDs with corresponding dosing times. The relevant variables are SubjectNumber, RECDATE, RECTIME, FoodType. Each patient doses twice a day, so ...
- 13
0
votes
3
answers
12k
views
MS Access: show only the max and min row using SQL
I have a little Problem with sql again :)
In this example I have to show the max ekpreis in one row and the min ekpreis in a second row. But with all the other data aswell. I tried select max(ekpreis) ...
- 897
2
votes
2
answers
1k
views
How to return the minimum and maximum record in one resultset (Microsoft Access)
I want to show the least and most expensive movie from a table. But the sql below does not run in Microsoft Access. How do I fix it so it returns both the min and max values in 1 result table?
SELECT ...
