View Full Version : ANSI SQL
Pages :
1
2
3
4
[
5]
6
7
8
9
10
- MS Access 2002 SQL
- Doubt in Index
- Need help with CURRENT_DATE and INTERVAL
- Programming a button control to copy data to another form?
- Access SQL problems using MS Jet OLEDB with ADO+VB6
- Sending data from a query to a table in access..is this possible???
- Same Phone Number for all searches
- SQL Performance Tuning
- Replacement for MAX statement?
- Probably Very Simple
- sql query help...
- Two SELECT statements
- SQL for search access database
- Nz syntax
- concatenate columns in sql 2000
- concatenate tables in sql 2000
- help!
- How do I connect to a diff database within a pl/sql program
- SQL Checkers Game
- Now I know!
- Dynamic SQL - pass table and column name
- TSQL Checkers Game
- Oracle: single-row search
- select * from table, but do a look up first..?
- Running a Sql query from Crontab.
- Using Cursors to find value changes
- Oracle SQL: Agg. Fn. Calculation
- Creating Record set using oracle procedures.
- Where Not Exists!?!
- Inner Join Question
- [SELECT] question
- Update query
- Return row even though search value is null?
- possible to move nodes in Nested Set Model?
- Pls Help - Urgent handling "-" in query
- Having trouble distilling something down to a single query
- CREATE TABLE with a DEFAULT for Microsoft Access
- Need help with this query
- prompt for value
- Informix SQL; finding the position of a substring
- Parenthesis in field value
- Advice badly needed
- Really confused in SQL statement
- SQL - Base table vs View
- Is Null, Is Not Null Statement
- multi-table join problem
- easy query for you...
- A new SQL parser
- I have a bit of a dumb question...
- Query Help for Newbie
- Registered Customers
- Please Help!! I'm going to JOIN a mental asylum!!
- Please help - Is this even possible??
- join
- count query problem
- Left Outer Join but right table has > 1 record
- Query Problem
- Query Problem
- Selecting exclusive items (In one table, but not in another)
- Problem with COUNT and HAVING
- SQL Analytic function
- Unexpected error
- New to SQL, but Learning, Query Help
- SQL Triggers
- Query help
- Newbie needs help with homework due today
- String equivalent to SUM
- Data Warehousing:Best way to write SP?
- Update table from an lookup table
- UPDATE and INSERT/ADD NEW in one query?
- Create a Database
- Insert syntax error
- Using SUM
- Please Help!!!
- Manipulating output
- Help on comparing values
- Comparing Tables By The First Seven Digits
- Working with money
- counting distint records
- SQL Server and Oracle's CONNECT BY costruction
- SQL Query Question
- A little help remembering how to do make table
- Trouble using SELECT to retrieve NULL data from a table
- SQL Input Data and Retrieve?(Oracle)
- delete the record i want
- Order by problem
- Want a help in Optimize a query.
- Alternative to GROUP BY
- Printing output even though no results found
- can somebody help my optimise my code please
- Subquery in the SELECT list
- Ingres equivalent?
- Percent of columns with a certain value
- conditional query
- Assigning FOREIGN KEY, which method is correct?
- SQL queries - about date
- left outer join
- SQL Problem!!!
- Trigger for checking daterange from two columns?
- Strange problem - no matching unique or primary key...
- Need some help, hint for query
- A little help, please?
- How do you aggregate on a group?
- not a GROUP BY expression????
- How do i "Join" back to the same table and fields ? Please help !
- Table Creation?
- SQL statement "not in"
- display result in one row
- using convert function for date in transact sql
- Need Help With A Query
- How to find a record by number
- can someone check this code for a nOOb
- Data Extract then create new table
- How to input?
- Input/output help? (Oracle 9)
- SQL / PL/SQL / DB Book
- SQL error in Oracle
- MSDE Engine Name?
- delete from certain point.
- help with query
- SQL question with dates
- Removing non-printable characters
- Another simple SQL query (MS Access)
- Deleting Spaces!
- match columns and replace according to match..
- Sorting SQL output when using "Group By"
- Merge table
- Need help with a simple set function query
- SQL Query crashes DB
- Deleting duplicate rows from a table, having no primary key
- the problem with isnull
- Convert Date with T-SQL
- Simple Data warehouse question (cursor)
- JDBC/ODBC driver compatible OLAP tools/server
- Select statement
- File format question
- update with jet 4 and ado error
- SQL average query
- Orlando MS SQL Server DBA Needed
- previewing specific records in a report
- The boss wants me to do this...
- Average query
- Populating a record
- SQL statement to sum rows, not columns
- getting the right reults
- MSSql & MySQL
- PL/sql
- Nameing a sub query for access to handle.
- About PL\SQL Trigger...
- Coverting Access data to SQL query
- count years
- Multiple row update ina table from another table
- how to retrieve distinct values
- exists: the absence of data
- row count column
- Get the month from a date field
- SQL Statements
- mysql
- How I can make it shorter...
- date
- performance issue
- First Date in the Month
- last value of database
- Comparing 2 tables
- Need help searching tables
- Help with SQL Query
- DELPHI and DTS
- SQL / Report help
- Reading a text file from a stored procedure.
- SQL + Crystal Report's Query
- inner join error
- Tools/Literature/Hints/any things to benefit SQL newbies.
- Max Dates For Cost Query
- Weird - can't find help anywhere! Duplicate answers
- Join on two seperate criterias
- Joining 2 fields: Redundancy results..need help
- cant get this boolean to work!!
- count for each month
- mutiple talbes query
- joining two results
- Help on joining tables
- Computer techies/ Engineers. IT people. Question about SQL.
- Utility to determin why a join breaks
- SQL Sub Query help
- triggers versus transaction ,Performance wise
- Query help... TOP 5,
- sql query
- linked server
- SQL statement- string to long error
- DateAdd function
- "Invalid Bracketing of name"
- listing only owners with more than one car query help
- char to total time
- SQL Query Help
- Simple SQL query help.
- Query to concatenate results from multiple rows
- distinct years
- loops in mysql
- update in mysql
- Question about a Select Statement
- Converting SQL numeric datatype to a mainframe (cobol) packed field
- triggers
- SQL group by question
- SQL newbie needing help with query!
- problem in executing procedure
- multi table UPDATE
- Update Query
- pl/sql
- Query involving join
- Probably Very Simple But...making a win32 executable .. execute
- Sql Help
- commas in col
- primary, secondary and cluster indexes
- pessimistic vs optimistic concurrency control
- need help with a query
- DB2K- VB6 execution halts in between...database error
- displaying non-duplicate keys of all duplicate entries
- SQL DTS error catching in .NET
- Showing only the first 30 results
- Automatically increasing field definition by SQL
- Pulling data across multiple tables.
- trigger
- Please Help With SQL
- Help with syntax please...
- Renaming files with DTS using ActiveX script task
- Reverse Engineer Hand Written SQL ( Oracle )
- Text to Time
- Temporary Tables,
- oracle pl/sql multiple spool help required
- Using a Select Statement Within an If statement
- Query problems
- Cant think how to do....
- Variables in sql select statement
- Sql server getting data with various intervals
- sql wont work
- Table Referencing
- SELECTing from a SELECT statement
- selecting the last two records
- Months and Years between Dates
- SQL Query Help
- Joins
- MS tSQL: Retrieving Anniversary Dates within 1 Week from Today?
- Error while opeing up a recordset in ado 2.5
- Regarding ODBC in SQL
- Regarding ODBC in SQL
- sql command?
- sql connection(urgent)
- Microsoft][ODBC dBase Driver] Unexpected Error From External Database Driver 10019
- is TOP 1 in JOIN possible
- SQL queries
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.