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!

Register Log in
  • Congratulations TouchToneTommy 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: jq65
  • Content: Threads
  • Order by date
  1. jq65

    Problem modifying a simple query into a subquery

    The following simple query executes ok select location_name, count(*) from observation where season (observation_date) = 'summer' group by location_name; Season is a function and the query returns the locations and number of occurences of a certain activity I now want to modify it into a...
  2. jq65

    Problem with date function using SQL Anywhere DBMS

    I am trying to create a function to return a specific month of the year after passing the function a date argument. I have first created a table as follows: create table season1 ( season_period CHAR(6) NOT NULL CHECK (season_period IN ('spring', 'summer', 'autumn', 'winter')), start_date...

Part and Inventory Search

Back
Top