View Full Version : ANSI SQL
Pages :
1
2
3
[
4]
5
6
7
8
9
10
- sub query grrrrr. help!
- ORA-00937 error
- Design Help!
- distinct: removing dups
- Combine and
- outer join
- Loading data from Mainframe to SQL-server
- renaming a table
- inner join
- Grouping, mins, and sums???
- how to ? GROUP BY?
- Need help with an SQL statement to get data from 2 tables
- How to get The Standard Query Language's general standard??
- count 2 value in a table
- calculate difference between rows (was "Sql")
- Any suggestions on how to revise code to accomodate order by issue
- [DB2] Update Field in Table A to a Field in Table B
- minimum and maximum in a time range (was "SQL query")
- Displaying the query result in one row
- Time Stamp Query
- SQL resourse
- calculations in a self-join (was "Query")
- MySQL DB Optimization
- Missing Values
- Triggers and Procedures
- selective update master table from another table
- Can't quite figure this one out... any help?
- speed comparison: integer - char(12)?
- Querying non-linked table
- Special Sorting of Fields with SQL
- Counting Unique Values?
- SQL Query problem
- problem with group by and maximum
- SQL Query:TEXT Data Type Operators
- Access returns blank results on localhost
- calculation values
- SQL - "format/input mask" in DDL
- Executing App with DTS, trouble with scheduling package
- sql text data
- calculation query
- Insert chars with line feed
- I need help with this sql string....('{0}', {1},'{2}', '{3}');", Chr(64 + j)
- Find Two Longest Serving Employees
- sql: GROUP BY trouble
- Sorting a query
- Create a View
- Trigger problem: No data found error
- Nasty grouping query
- POs and closed PO lines (was "I think this is an easy one..")
- Sql Query: trouble joining
- commas
- cleansing data
- Removing dupes (distinct like)
- Update method with now() function
- Sum by month
- need help using 'IN'
- Beginner with crosstab queries
- Duplicate Rows Blues
- Min Function Problem
- avoiding duplicate lines
- Beginner question on Altering constraints in Tables..
- asking help on Full Outer Join on multi-tables
- Number conversion
- Problem using SELECT statement on Access Column Name
- i am having an issue with my trigger code
- Very beginner needs help with Cobol & SQL
- Looking to learn SQL
- Calculating dynamic values for shopping cart quantity
- JOIN to get rows in one table that are not in the other
- Req help with data types/domains
- Need help for mysql statement. urgent
- "Converting numbers into Dates"
- replace a column with the contents of another with SQL?
- Joining Tables
- SELF JOIN help needed
- Help needed to generate a "sort code"
- Summary Of Data
- SQL Servers view meta data(urgent)
- Using C++ Builder and Database Desktop db connections
- Double join... kind of...
- Help if possible
- Sql Statement
- seperating info from a query
- Triggers
- Max Count(*) question
- new sql searching
- self-join help
- Describe command.
- Re: How To Misuse SQL's From Clause
- Combining info from two tables?
- Problem with Sum function in Access
- Delete to (error message)
- Delete more than one table
- SQL (Return the number of row)
- How to get output of sql command in columns
- Help with sql query
- Statement converting Columner to Tabular
- rollup data rather than numbers?
- query w/ case help
- SQL0418N when inserting with select from the same table.
- Foreign key
- Relatively easy SQL SELECT statement issues :/
- Import/Export
- Easy query help... :(
- Query to obtain missing number
- UPDATE multiple rows
- obtaining parameters from a combobox
- SQL Latest Date Query
- Syntax error in CONSTRAINT clause
- New to SQL
- duplicate results returned in query
- select into
- Need Query Help (with a COUNT(*) for listings) please..
- Special ordering
- Please Help
- Create a Updated Form?
- dateformat
- DSN Connections in SQL DTS
- Synchronising Access and MySQL databases
- union between different databases
- SELECT query combining two field ids
- Need to Optimize the SQl Query
- Selecting across a many to many relationship
- Table join and sub-query optimisation?
- Top Five Of Each Group
- Echo for SQL scripts
- Max function
- deleting data from database
- Use time in Sql (Problem)
- reverse pivot
- Select query between two figures
- Combining LEFT JOIN and MAX
- Copying record with non automatic primary key
- need to get sth which is more than avg
- error sqlcode -902
- "Sql" Is it possible!!
- Complex relationship
- Create Table Question
- just query
- sql insert problem in asp
- returning total records using count
- database user post extraction
- inner join query help
- Two tables update at the same time.
- sql headach
- insert into a table from another table
- stored procedure
- query by recent dates
- database inconsistencies
- Help with query - selecting min value
- max no. of values in WHERE ... IN clause
- How to some text withing a field
- Installing Local SQL2000 Personal Edition
- What is the benefits of having SQL server software?
- SQL query from web page?
- Urgent: How to concatenate?
- Sql (Inner Join)
- SQL in a CL
- SQL syntax problem
- Any code for automatically inserting queries of first table into the second?
- distinct query & a union of some kind?
- Simple SQL Query
- sql query
- Format Date
- who can help me ? it is urgency .thanks
- Db-library network communciations layer not loaded
- LEFT Join with multiple tables in SQL query
- Question about Max function
- SQL Question
- SQL to search with multiple criteria
- SQL Enterprise Manager - Design mode Question
- How to sum multiple fields together
- Sql please help !!
- SQL Operators
- Return one result from a vertical table
- Union Sql Type: Error
- query optimisation question
- inner join problem
- Delete statement trouble
- UNION in subqueries
- 547 error: help decoding
- 547 error: help decoding
- Retrieving rows with 2 indexes
- OCR Features
- Issue on SQL in MS SQL2000 and Access
- How to get A list of table in SQL database ?
- selecting from a query
- Count for each word in a field
- Problem with Capital Field names in db and sql statements in small letters
- Update by Key
- Placing Notes In Sql Statement
- Updating a table row, how?
- summarize subqueries
- Select stmt on Column Name that is also a system function name
- "Case insensitive" index
- Tab-delimited format
- Selecting "month/year" from table
- How to delete all rowa in all tables of a schema in Oracle?
- Subquerying
- Newbie Q with SQL
- Null record
- NewB- Selected Data transfer from tables
- SQL%NOTFOUND not working
- Null values in queries...
- In need for a solution for practical problem
- Select rows with one distinct column help
- how can i get a list of tables ?
- .LST a .TXT
- Question about GROUP BY and Views
- Need to know how to optimise an SQL statement
- Looking for help with an SQL query.
- query help
- Select Where
- SP Version
- tough query help
- Problems with Analysis Services running on Citrix client
- Consolidation Query
- Can we speed this up?
- Answers needed for these multiple choice questions
- Semi-complicated query
- How to select 5 results only ?
- Newbie help On Sql string form vb
- Help need on column reference constraint with trigger conflict
- create temporary table in linux
- Help: Selecting from two tables: odd situation
- Trouble w/ order by on a Union
- Check for duplicates
- A syntex problem.....I think
- SQL: NestedSet Tree, getAncestors() with level
- Passing Index Value
- Analyze 2 Columns in 1 Table
- Multiple Table Combination
- Difficult SQL
- question on join
- argh...date problems
- How to get column titles ?
- sql syntax in other languages than English?
- no records are displayed?
- SELECT DISTINCT in multiple colums
- Image Data Type
- Dumb Newbie
- Sql Server 6.5 Service Pack help required!
- Exclusive selection
- Sorry guys I have to reask.
- Complex Query Help.. Please :)
- Please help!
- Access 2002...
- integer count
- SQL in Oracle 9i, merging columns
- book on EVERYTHING in SQL
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.