- recursive Query/hierarchical query
- sending multiple mails
- Help
- Modify Display Results III
- Modify Display Results Take II
- Modifying Display Results Part II
- Modifying Display Results
- multi-db web app
- Problems using set operators
- multiple values query
- GROUP BY date
- Update Multiple records from one date field
- Transforming relational tables
- creating table from antother user table
- ORDER BY - query
- Need help with count/matching query
- WHERE clause fails in multiple joined and grouped CF query
- Group by question
- Building classes
- How to Get Field Data Type
- Help divvying up query result into seperate tables
- help with an SQL query and group by/sum
- return Customer even if no match in Contract (was "Help with simple sql")
- SELECT COUNT DISTINCT problem
- Multiple records with the same value in one field
- T-SQL Inner Join with where criterion?
- How to join two tables?
- complex query - 2 tables
- Postcode Midpoints
- Simple Query Takes 10 Seconds To Execute
- Dynamic query, variable columns returned
- Union problem (how to combine the field with different data type)
- union select tuning: what's the format for a database function with union select
- SQL Server query
- Dynamic SQL or Stored procedure?
- unknown error source
- Combining 2 SQL Select statements
- concantonation
- Project Hours and Totals
- users who have visited New York and Miami (was "Help on query")
- Escaping the Apostrophy
- Indexes (The Basics)
- Union results not what expected
- sql:is-constant Alternatives
- Insert... Where?
- I Need Help in Creating a Query
- Need help truncating column data
- where not exists
- Create Oracle DMP file in SQL
- Joining multiple rows from a single table
- Query to get latest versions of items
- Embedded SQL programming
- Weird UNION artefact
- Table Limit Exceeded
- counting aging groups
- SQl calculation error in ASP.
- Format output of numbers
- how to check varchar2 as a date
- "order by" on a value associated with a foreign key
- HELP! 2 tables into 1 long table.
- union two columns? it's that possible?
- Query Optimization Books & links needed
- Subqueries
- Changing the max characters attribute!
- Joining an archive table to a current table
- get row for each unique name
- sorting problem
- Aggregates in Multiple Table Joins
- subtract total vacation days taken from allowance (was "Newbie seeking help")
- query using count and order by
- query for same fields from two tables
- How to use Order By
- Count Rows From Two Tables
- Delete a user after 10 days? (reference to php forum)
- Need Advise On My SQL Statement
- Rationale of OVERLAPS
- Advanced query...
- how to select Max value in table 1 < value in table 2
- Can this be done in one query?
- LEFT/RIGHT JOIN not working....
- Select closest match query
- matching dates via checkboxes (was "SQL Query")
- select 1 random record in top 100 ??
- Outputting blank values instead of the actual
- sql based on text box
- SQL - Updating records in a one-to-many relationship
- contains this but not that...query
- translate two codes (was "Sql Join Query Help")
- record values
- If Then Else??
- Max number in subquery...
- Data for a particular item for maximum purchase date
- how i add order field in result query
- finding records with duplicate data
- Intervals Over Time
- parent and children items in query??
- How to get the first record in a parent-child data?
- Grid/table editing icons
- Basic SQL Query Problem
- select employee associated with max date (was "Need some SQL Help")
- SQL syntax when working with a lot of SQL?
- How do I select repeated number??
- Subselects and UNION
- Adding String data
- Is there a faster way...?
- How to find patterns in numbers
- max date
- check if table exist
- Exporting results into Excel
- Problem with join...
- Join 2 tables by referencing columns with data
- How to find specific orders from a list of products
- relational algebra
- Self join?? Not exisits??
- PL/SQL call function from trigger
- select from 2 table
- Want to pass parameter value back to Korn Shell
- Need to tie transactions to months... not sure how.
- howto use something like 'ILIKE'
- "distinct" query-want to retrieve all columns!
- select all unik groups
- insert special character
- Displaying user specific information
- sort by availability, priority and first request
- Two table SELECT statement
- employee hours spent on a project (was "Another SQL question I'm afraid")
- course that employees have not taken (was "SQL Question")
- students who have not taken a course (was "SQL Question")
- Update the table
- using self join and non-equijoin
- calculation on the fields
- having clause returns no results?
- Problems with "search engine" query
- Problem with DISTINCT
- What's wrong with this query
- what is the query for getting first 10 rows of a column
- Max(Date) and Calculated Fields
- Same Records
- Calculating a percentage in a query
- Creating a new Table from others.
- AND and OR in WHERE clause returning too many results
- Aggregate Function
- select projects where module_code not in allocate table (was "sql query help")
- Rounding up in SQL
- how to get started on homework assignment (was "SQL Help")
- Combine colunmn
- comparing 2 tables & writing data to 3rd table
- Manipulating Date Functions
- Nesting select statement inside delete
- Query construction
- minimum number of Field G where Field K is 7 (was "Help for an sql-command")
- sql selecting data using user selected date range
- get expiration date from next effective date
- Select Distinct Record
- How to enter this command line sql statement...???
- Running a sql to find blanks or empty space in database
- Need a Help on Query
- Need SQL Performance Advice (Scenario Given)
- construct hierarchy
- SQL help
- Help with HOUR() query
- why we can't assign an SQL query to a variable?
- Help with sorting strings...
- two highest and three lowest salaries (was "Query")
- max(tag) for pair of matched rows (was "Need help on query")
- text and numbers
- Question about Aliasing?
- unequal fields in one and two tables (was "simple query: but i cant seem to get it")
- SQL's GROUPBY logic
- Query and textbox difficulty.
- Allow space in data
- Construct a query.
- Unique SQL issue using a wildcard in my where statement
- two FKs to same description table (was "I don't know how to word this title?? :)"
- Listing rows "missing" information?
- Determining Indirect Bus routes: SQL problem statement
- three table not exists problem (was "I need help!")
- Searching unreleated tables
- Select one if active else another
- Delete across tables
- SQL Left join with select criteria
- SQL - conditional join (?)
- Update with case
- SQL parcing
- record deletion problem
- Correlated SUB Queries?
- query result to xml file
- SQL Statements and Data Types
- Working With Multiple Queries
- Count in Empty RecordSet and BOF/EOF
- get 5 rows from 2 unrelated tables (was "Complicated sql query.... need help badly")
- BETWEEN statement
- Sql Error, Why?
- Good resource ?
- need a query to join 3 tables
- date...
- High Light Words in Query
- Left outer join problem
- Dynamic or Static SQL exact definition...
- Joining Two tables
- Online SQL reference
- Repeated Value
- Can't Use Distinct here!
- 4 queries into 1 query
- select max(count of rows) (was "SQL")
- customers in 2003, not 2004 (was "Help with (probably) simple query")
- field in a table that stores my IN condition (was "In")
- Performance Q's
- insert date problem
- left join problem
- outer join operation?
- Multiple rows into one query result row...
- exclude a field from a wildcard search (was "A simple question! (heeelp)")
- Comparing two tables with different fields
- line numbering in result set
- Novice SQL questions
- Like Statement SQL Suery
- heading size
- Pivot Tables using SQL
- Help please! Problem with a particular date in SQL command?
- help with update query
- Recording the time
- using wildcard character in select statement
- trouble counting SUM GROUPed BY
- Join tables and exclude records...
- A way to "SELECT constraints FROM table"
- Drop Relationships
- Email passwords
- automatically send a notice after 6 months (was "Date Question")
- Deriving data from nothing?
- problem when addin an extra field to a select
- A simple varchar comparison
- Delete duplicate records in table
- how to increment an integer
- PL/SQL help - split an address
- can somebody please help me with my query?
- Investigate Unknown database file type?
- Calculating movement
- Complex Query or just me?
- SQL Query...
- comparing long varchar to char problems
- Convert datetime to seconds
- Images...Help!
- differenct between 2 select statments
- GROUP BY rule holding me up - HELP!
- inner join problem
- Analysis Manager Profiler
- 'tables' of data
- Getting records that only exist once.
- MS-SQL SQL to Access SQL