View Full Version : ANSI SQL
Pages :
1
2
3
4
[
5]
6
7
8
9
- How to understand database task?
- Using multiple ANDs in a statement
- Using the Count expression
- Joining Excel Database with MSDE Database Table, & Import
- Need help on SQL query
- Foreign Key Referencing more than 1 table?
- Getting value of auto increment key field
- Help with SQL query.
- Help with SQL Function - Can't change Null value
- Create a login table question
- Decode XML text field to display my image
- MAX function -1
- SQL 'Order By' problem
- Selecting from a particular table.
- HELP: Histogram
- SQL query results - help please
- Expected end of statement
- Date Time Format
- Dynamic display of SQL in Excel?
- excel sql query type mismatch error
- Like Statement Dosent Work
- SQL, Two views into one
- How do i get seq.nextval from within a pl/sql function
- ORDER BY using a list of elements
- how to tell the difference between upper and lower case?
- SQL JOIN/SUM query help
- select sum statement
- HELP !!! - How can a run a sql script to install a DB in a MS SQL Server?
- Sum() statement is not working correctly.
- Need 2nd set of eyes on a CASE statement
- count distinct
- access to sql query issue
- Access 2000/SQL 2000
- OleDbDataAdapter MDAC problem
- SQL Command Line Consolidation
- to get the max value
- What SQL db can run on SCO Unix Openserver?
- Triggers in windows application ^_^!!!
- Self Join
- Trying to select rows that aren't there.
- Grouping and TOP 10
- Joining multiple tables and picking out latest date
- is this possible? ...not an SQL master
- Query Help needed
- Count ?
- need this ASAP: what's the sql statement for
- how do I return the highest date per group
- Logical Operators in SQL statement
- Creating Access tables in SQL
- Many-To-Many
- Self Join
- Join.
- How well is your SQL? A homework.
- Nest LEFT JOIN in an INNER JOIN expression
- select based on previous date value
- several outer joins on the same table in access
- Accessing a remote sql server from a local machine
- SQL Problem returning data twice
- Help with what should be a simple delete?
- viewing multiple columns
- Triming Data
- Trimming Data
- Simple SUM Distinct Question
- Cannot find file or directory?
- Supporting oracle and sybase from Solaris C applications
- select with wildcards
- IN operator
- grouping by the avg
- clear identical submissions
- Select error?
- SQL script to start search from a row number and next n number of records
- Problems with myconnection.Open()
- select statement
- Stored Procedure
- select statement
- self-join, MAX and MIN
- SQL statement tuning
- Oracle SQLPlus Worksheet
- Group By Count
- contains operator
- convert value to 2 digits after decimal
- parent child, display as follows - possible with SQL?
- Query Help
- special character handling
- select range
- SQL Function Query
- MSDE login using PHP
- your opinion on this sql please
- Restoring Database to PRE-Replicated State
- Table name in a stored procedure
- whats wrong with this update statement
- Running SQL query in HUGE database
- summation of group data
- Searching a db
- Trigger to Insert or Update 2nd Table
- SQL Server Select Into Local Access DB
- How to use Parameter Query for SQL IN staetement
- Insert Command
- Nested loop SQL
- Select from table, reinsert data but update one of the columns
- Insert some texts into a table by enterng data in a form
- Another n00b select statement problem...
- Verification Of Details
- Double Inner Join
- ROWNUM and ORDER BY
- phpbb from Ensim to CPanel
- Homework assignment
- Delete Duplicate records
- LIKE Condition Pattern List ?
- Reading a file using UTL_FILE.
- Display 2 field of database in form <select>
- email sql command
- Concatenating a Single Field, Multiple Records
- SQL Statement Woes
- SQL queries
- is TOP 1 in JOIN possible
- Microsoft][ODBC dBase Driver] Unexpected Error From External Database Driver 10019
- sql connection(urgent)
- sql command?
- Regarding ODBC in SQL
- Regarding ODBC in SQL
- Error while opeing up a recordset in ado 2.5
- MS tSQL: Retrieving Anniversary Dates within 1 Week from Today?
- Joins
- SQL Query Help
- Months and Years between Dates
- selecting the last two records
- SELECTing from a SELECT statement
- Table Referencing
- sql wont work
- Sql server getting data with various intervals
- Variables in sql select statement
- Cant think how to do....
- Query problems
- Using a Select Statement Within an If statement
- oracle pl/sql multiple spool help required
- Temporary Tables,
- Text to Time
- Reverse Engineer Hand Written SQL ( Oracle )
- Renaming files with DTS using ActiveX script task
- Help with syntax please...
- Please Help With SQL
- trigger
- Pulling data across multiple tables.
- Automatically increasing field definition by SQL
- Showing only the first 30 results
- SQL DTS error catching in .NET
- displaying non-duplicate keys of all duplicate entries
- DB2K- VB6 execution halts in between...database error
- need help with a query
- pessimistic vs optimistic concurrency control
- primary, secondary and cluster indexes
- commas in col
- Sql Help
- Probably Very Simple But...making a win32 executable .. execute
- Query involving join
- pl/sql
- Update Query
- multi table UPDATE
- problem in executing procedure
- SQL newbie needing help with query!
- SQL group by question
- triggers
- Converting SQL numeric datatype to a mainframe (cobol) packed field
- Question about a Select Statement
- update in mysql
- loops in mysql
- distinct years
- Query to concatenate results from multiple rows
- Simple SQL query help.
- SQL Query Help
- char to total time
- listing only owners with more than one car query help
- "Invalid Bracketing of name"
- DateAdd function
- SQL statement- string to long error
- linked server
- sql query
- Query help... TOP 5,
- triggers versus transaction ,Performance wise
- SQL Sub Query help
- Utility to determin why a join breaks
- Computer techies/ Engineers. IT people. Question about SQL.
- Help on joining tables
- joining two results
- mutiple talbes query
- count for each month
- cant get this boolean to work!!
- Joining 2 fields: Redundancy results..need help
- Join on two seperate criterias
- Weird - can't find help anywhere! Duplicate answers
- Max Dates For Cost Query
- Tools/Literature/Hints/any things to benefit SQL newbies.
- inner join error
- SQL + Crystal Report's Query
- Reading a text file from a stored procedure.
- SQL / Report help
- DELPHI and DTS
- Help with SQL Query
- Need help searching tables
- Comparing 2 tables
- last value of database
- First Date in the Month
- performance issue
- date
- How I can make it shorter...
- mysql
- SQL Statements
- Get the month from a date field
- row count column
- exists: the absence of data
- how to retrieve distinct values
- Multiple row update ina table from another table
- count years
- Coverting Access data to SQL query
- About PL\SQL Trigger...
- Nameing a sub query for access to handle.
- PL/sql
- MSSql & MySQL
- getting the right reults
- SQL statement to sum rows, not columns
- Populating a record
- Average query
- The boss wants me to do this...
- previewing specific records in a report
- Orlando MS SQL Server DBA Needed
- SQL average query
- update with jet 4 and ado error
- File format question
- Select statement
- JDBC/ODBC driver compatible OLAP tools/server
- Simple Data warehouse question (cursor)
- Convert Date with T-SQL
- the problem with isnull
- Deleting duplicate rows from a table, having no primary key
- SQL Query crashes DB
- Need help with a simple set function query
- Merge table
- Sorting SQL output when using "Group By"
- match columns and replace according to match..
- Deleting Spaces!
- Another simple SQL query (MS Access)
- Removing non-printable characters
- SQL question with dates
- help with query
- delete from certain point.
- MSDE Engine Name?
- SQL error in Oracle
- SQL / PL/SQL / DB Book
- Input/output help? (Oracle 9)
vBulletin v3.5.3, Copyright ©2000-2008, Jelsoft Enterprises Ltd.