Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: wylliecoyote
- Content: Threads
- Order by date
-
One more question
I am inserting this into my SQL command and it is making my formula redundant since there are 6 null rows. How do I do this so it will only use one the min date_hired field where there is a null date_released field? lecturer.date_hired < (select min(attendance.regstrn_made_date) from...- wylliecoyote
- Thread
- Replies: 10
- Forum: ANSI_SQL
-
Query selecting Average < 650
I need a query that will select only those student IDs with an average amount_paid less than 650. So far I have this written out and it works for returning the data with the criteria given. What would I add to only select where the student_id is less than 650? I have been working on this for...- wylliecoyote
- Thread
- Replies: 3
- Forum: ANSI_SQL
