here is my question with getdate function
--12. List the names and staff number for staff who manage detached properties that have a current lease i.e. there is a lease and its end date is in the future. Show each staff member only once
-- (Hint the getdate() function returns todays date)
i have this so farr
select fname, lname, s.staffno from staff s inner join property p
on s.staffno...
napjohn8
Last Activity: Mar 31 '08, 03:59 PM
Joined: Mar 1 '08
Location:
-
getdate function help
-
Greater than statement for 2 columns
hi guys,
i am doing an SQL question where the table is item and the two columns i have are reorderlevel and QOH
The question is List details for the items where the qty on hand exceeds the reorder level by 10 or more.
I have so far
select * from item
where QOH >
No activity results to display