- Need help on query!
- What's the Best Table Structure for a Membership System?
- Pls Help to Get Result..
- Not sure why this sql isn't working (NOT IN)
- Need help in writting query
- Help with an sql query...
- aggregation problem
- How do I redirect output file using SPOOL
- Concept of this SQL query
- Inner Join
- Looking for help with an unmatched record query
- Count Question
- SQL query construction question (selecting particular records from child table)
- Max
- compare two tables records using cursour
- Join on 3 tables with wild card for Search
- If else?
- Help with sorting results
- Strange results when working out average of a count
- SQL Term and Example?
- retrieving information for many tables??
- Multi-Row-Update
- Help with a very slow SQL-Statement
- List 3 tables
- difference of two queries
- query to display gaps in dates
- how do i insert a null value from a script ?
- SQL Query Help (Please)
- aggregate of an aggregate
- Using count(*) in where question
- beginner question!
- ANSI syntax for joining 4 tables-am I correct?
- Trying to get rid of subqueries
- a tricky sql query
- How to Return Moving Differences with Grouping?
- max date with specific criteria from same table
- how to duplicate a row where tables are linked
- Counting values into separat columns
- using OR vs using Union
- help on a join query
- Question for pat phelan
- Trouble with querying
- selecting unique values problem
- sum of counts of same data existing in 2 different tables
- sum of counts of same data existing in 2 different tables
- 3 table outer join problem
- Any limits to using 'IN' with sub query?
- sql query help/problem
- How to return only 1 row
- Help needed with Joins
- Update using Corelated sub query
- SUM for DISTINCT rows
- Identical BOM's
- data based on unique values in another column
- Help needed in forming a query
- How can i compare smallint and int
- How can I create a Query based on a Table?
- sum of record counts provided by correlated subquery
- Query Top 5 item related
- Help with scalability design
- Update table from subselect openquery (SQL2K5)
- Need help formulating a non-equal join
- Help with table JOIN
- How do I display 2 column table as a 8 column table
- grouping results of group by?
- After combining tables, how to avoid sub queries?
- Trying to get two counts from same joined tables
- Wisegroup
- can DECIMAL columns be unsigned
- delete and update properties for primary keys? (was "nother n00ber")
- key constraints inline or separate? (was "primitive n00b question")
- Join question
- order of tables in a join
- Back Again!
- Newbie Question...
- Querying Strategies
- SQL conversion
- Getting the maximum value in a join and displaying the result as one
- SQL Query to order a list
- sql book recommendation
- delete query help
- query help
- Constraints in Tables
- Max() on JOIN subquery with extra columns
- Update From
- SQL - Multiple text values in the same field
- Partition By clause in ANSI SQL
- Calculation query
- SQL Join Query Syntax
- what column to index?
- How to return a fixed number of rows?
- Searching for logical combination of tags
- Update query Issue
- Do not want to use UNION ALL
- view and insert/update?
- Query Help
- increment by one while ?
- ANSI SQL Built-in Functions
- Help formulating a query
- the more performatic sql
- Copy record from Table to Table
- help with join query
- SQL Query for one field with multiple values
- Ansi Sql 87
- Sorting in UNION ALL
- JOIN vs Agregations
- NOT EXIST Is there another way?
- Inner Join Issue
- SQL Query
- Eliminating rows from select results
- Sum function with logic?
- SQL Counter function based on Access DB
- a small SQL help regrading a criteria
- Recursive Query or Procedure
- Select statement with sub-query not returning any rows
- Union All
- change datetime to date
- Simple SELECT * (easy one)
- Ansi
- Append Data
- Is there a point to not using joins?
- Accessing substrings
- is null or nvl()
- Getting The Latest Record
- Distinct & eliminate duplicate data
- List of cities and countries
- Kind of simple join question. Not sure if it's that
- group several rows in a SQL query
- Filling out missing data in subsequent records?
- Create row from number range
- Help on delete statement
- SQL to find if field is low values
- index column names in a database
- Join 2 SQL statements
- if row exists update count, else insert
- Substring
- Error converting data type varchar to float.
- minimum price on earliest date
- Calling SQL Guru's (query help needed!!)
- Return Values on conditions
- Is it possible to optimize DB by this strange way ?...
- Need Help on SQL statement
- float4
- Check for duplicate before insert with composite key
- Conditional SQL Statements?
- Entities
- Normalization
- Can SQL find duplicates within a "range" of numbers?
- select with max function
- Inner Join statement Vs AND operator
- Question on SQL experission for complicated query
- Problem With Distinct clause
- Selecting Individual Rows From Joined Table
- how to accumulate values in different columns ?
- sql and case statement
- union all order by
- A SQL query !
- Select , populate from diff tables based on condition
- Duplicate xReference Fields in 1 query ?
- Retrieving data from 4 tables
- Grouped by Using aliased names
- Generalisation schema Help(GIF Schema included)
- Use bit in SQL?
- Fan Trap or Multiple one-to-many joins
- What's wrong here? (NOT IN)
- Finding number of repetition T-SQL
- SQL Query - SELECT from multiple tables
- Order by clause
- need help with multi-table update
- Queries mixing two tables (beginner)
- SQL statement giving me trouble
- Noob Query Problem -This will be easy for you
- Selecting top date
- SQL - Stored procedure
- Selecting duplicates only
- How do you find Deleted D/O No.
- Order Products Based On Sales
- Help with nearest neighbour problem
- Sql Query for Team hierarchy
- Advanced SQL tutorials in Problem/Answer format
- reference numbers whose status is not 2 (was "SQL Newbie looking for a little help")
- Help needed for the following scenario
- SIngle Quotes
- simple SQL query
- Need a second opinion
- Stored Procedure trigger help
- select statement to replace a character in field?
- Count of Invoices for Each Hour
- Query syntax: select parent record, including number of children?
- Replication error
- Lag function
- need help with multi-table query
- Error Code 1062 and 1053
- query, special transpose and merge of data
- error creating cursor handle
- Join Issues
- external data
- 5 Database Queries to go with an online purchasing system :-)
- Problem need help
- maximum age
- table cannot have more than four row under car_id (was "hi")
- Complex SELECT QUERY using look-up tables
- Subquery Question
- sorting but always having specified fields come up first
- Convert columns into rows + construct query.
- "Limit to List" equivalent in SQL
- which field shld i use?
- How to change the content?
- Rate Table - Need Help To Display Data Horizontally
- backup operator
- Matching Debits and Credits query
- help with SQL queries please
- Combine multiple rows into one
- Doing a lookup between tables
- basic sql question
- join and only include rows where a value is max()?
- Double left joins with conditions
- multiple db, table, column query
- IN vs OR
- Sorting by Time
- Query no returning desired resluts, HELP
- Sql Query Help!
- Distinct values
- exists and in clause
- Joining multiple pks
- How to display rows as columns
- Query: inner joins on two columns.
- Ideal setup of tables for many categories and many sources
- Database work
- Selecting based on child row content
- SQL Injection
- Can't Seem to Figure out a Trigger...
- Field name in LIKE statement
- rewriting SQL to avoid multiple scan of a table
- Easy query help
- SQL query help
- select nur einen datensatz
- Join Query on a PK
- Help in using/learning SQL
- Help with SQL query
- Fixed text in SQL being truncated
- UPDATE using a JOIN
- Urgent SQL question
- Need help with query please
- Random row list
- Adding information into one field that depends what is in another
- query runs in Query Analyzer but not in Access (was "Help my query, please")
- Cumulative Field
- looking for dups SQL statement
- Help with SQL query is required please