View Full Version : ANSI SQL
Pages :
1
2
3
4
5
[
6]
7
8
9
10
- SQL Statement Woes
- Concatenating a Single Field, Multiple Records
- email sql command
- Display 2 field of database in form <select>
- Reading a file using UTL_FILE.
- LIKE Condition Pattern List ?
- Delete Duplicate records
- Homework assignment
- phpbb from Ensim to CPanel
- ROWNUM and ORDER BY
- Double Inner Join
- Verification Of Details
- Another n00b select statement problem...
- Insert some texts into a table by enterng data in a form
- Select from table, reinsert data but update one of the columns
- Nested loop SQL
- Insert Command
- How to use Parameter Query for SQL IN staetement
- SQL Server Select Into Local Access DB
- Trigger to Insert or Update 2nd Table
- Searching a db
- summation of group data
- Running SQL query in HUGE database
- whats wrong with this update statement
- Table name in a stored procedure
- Restoring Database to PRE-Replicated State
- your opinion on this sql please
- MSDE login using PHP
- SQL Function Query
- select range
- special character handling
- Query Help
- parent child, display as follows - possible with SQL?
- convert value to 2 digits after decimal
- contains operator
- Group By Count
- Oracle SQLPlus Worksheet
- SQL statement tuning
- self-join, MAX and MIN
- select statement
- Stored Procedure
- select statement
- Problems with myconnection.Open()
- SQL script to start search from a row number and next n number of records
- Select error?
- clear identical submissions
- grouping by the avg
- IN operator
- select with wildcards
- Supporting oracle and sybase from Solaris C applications
- Cannot find file or directory?
- Simple SUM Distinct Question
- Trimming Data
- Triming Data
- viewing multiple columns
- Help with what should be a simple delete?
- SQL Problem returning data twice
- Accessing a remote sql server from a local machine
- several outer joins on the same table in access
- select based on previous date value
- Nest LEFT JOIN in an INNER JOIN expression
- How well is your SQL? A homework.
- Join.
- Self Join
- Many-To-Many
- Creating Access tables in SQL
- Logical Operators in SQL statement
- how do I return the highest date per group
- need this ASAP: what's the sql statement for
- Count ?
- Query Help needed
- is this possible? ...not an SQL master
- Joining multiple tables and picking out latest date
- Grouping and TOP 10
- Trying to select rows that aren't there.
- Self Join
- Triggers in windows application ^_^!!!
- What SQL db can run on SCO Unix Openserver?
- to get the max value
- SQL Command Line Consolidation
- OleDbDataAdapter MDAC problem
- Access 2000/SQL 2000
- access to sql query issue
- count distinct
- Need 2nd set of eyes on a CASE statement
- Sum() statement is not working correctly.
- HELP !!! - How can a run a sql script to install a DB in a MS SQL Server?
- select sum statement
- SQL JOIN/SUM query help
- how to tell the difference between upper and lower case?
- ORDER BY using a list of elements
- How do i get seq.nextval from within a pl/sql function
- SQL, Two views into one
- Like Statement Dosent Work
- excel sql query type mismatch error
- Dynamic display of SQL in Excel?
- Date Time Format
- Expected end of statement
- SQL query results - help please
- HELP: Histogram
- Selecting from a particular table.
- SQL 'Order By' problem
- MAX function -1
- Decode XML text field to display my image
- Create a login table question
- Help with SQL Function - Can't change Null value
- Help with SQL query.
- Getting value of auto increment key field
- Foreign Key Referencing more than 1 table?
- Need help on SQL query
- Joining Excel Database with MSDE Database Table, & Import
- Using the Count expression
- Using multiple ANDs in a statement
- How to understand database task?
- Un-expecte cases
- Database task?????
- Creating Output in columns instead of Rows
- Adding a line number to SQL Output
- Finding the rank.......
- Finding the n.th higest value
- Access equivalent to @@identity???
- NEED HELP with finding duplicates
- Batch query : NEED HELP!
- sproc SPACE ->
- SQL statement to update a csv field with csv values
- SQL Question
- SQL INNER JOIN help
- Dissolve based on common value
- datediff problems.
- case statement with an sql query statement
- SQL many-to-many join
- SQL Query for DATE Field
- Help needed on Sql query with Time functions
- help me pleeease, im so confused
- Subtracting Time in the same table
- Calling a VB function/sub from SQL
- Multiple INSERT
- DBMS_OUTPUT.PUT_LINE truncates leading zero
- Running Query off the results of another query
- SELECT statement doesnt work
- sort help (1 table)
- group by date
- Join, Count and Group By
- SELECT MAX(Time)
- Problems with null values
- Running a delete, insert, update SQL statement from a text field
- Compare last character of a shell variable
- Passing value from PL*SQL to the calling unix shell script
- SQL Delete Query
- vb6 and access sql parameter query
- parameter query of vb6 and access
- LIKE problem
- Any Good Book Recommendations?
- SQL Query Problems???
- Query gurus please?
- SQL Database Help
- Can I Query a Form?
- Urgen Help!Republication error
- I need to execute TWO SQL statements...how?
- Urgent help with SQL query!
- help optimizing query
- Multiple inner joins on same field or nested query?
- All from one table and all from another
- Meta Database Design Select Question.
- Correct syntax on this SQL INNER JOIN Query.
- Runtime Error '3146' ODBC--Call Failed
- SQL for searching on many fields when only some have values
- If, Then (case) statement
- how do i query a m to n (many to many) relationship?
- Problem with SQL string using MS Access and OleDbConnection (ASP .NET)
- union & grouping
- Multiple Possible Parents
- SQL Select query (with many-to-many)
- Including/Comparing massive amount of locations to ip-adresses in SQL Query. ??
- SQL Statements - Client/Server
- Returning fields that have changed since last import
- Retrieving sub trees and levels in a nested set
- The conversion of a char datatype to a datetime datatype resulted in an out-of-range
- Query help needed...
- Enhance SQL Script
- [OMWB] SQL 2000 TO ORACLE9i
- Comparing tables
- Date Function on Redbrick or Oracle
- combining fields (sort of)
- cross platform derived table query
- SQL Query Help
- Select first 10 records of a file
- where to begin learning sql/oracle?
- Delphi ADO Parameter Query
- Where to go from here?
- Oracle 9 ODBC Timezone field support
- Conversion of Reg.Exp in money....urgent
- Expand table rows based on two column ranges
- SQL learning resources online
- cfgchar.exe and .OUT files
- SQL Query Problem
- Calling a SP using For XML
- Replace character from string
- SQL - If Then Else Statement
- xml explicit
- NB: query troubles
- search function
- basic PL/SQL question
- Recordset Counts
- How to consolidate the count?
- Difference between two sets
- sequence in trigger
- Documenting Crystal rpt files
- problem with NULL values in sql statement
- SQL Query
- How to inquire on column headings?
- Calendar for Oracle Forms
- subtracting 2 hours from date returned
- help with limiting query results
- sql help
- Multiple-Parents
- How to format numbers in a query
- How to undo Transactional Replication with immediate updating
- Sequence?
- Update table from values in another..
- How to do it in one insert statement? Please come in
- Pls help me with this SQL CASE WHEN (on ASP)
- CASE statement
- multiple field "search and replace" query
- What's wrong with my SQL Query??
- Basic Question about password and logon command
- how to fetch subset of records
- procedures inside a package
- trigger (instead of?)
- Calling Java Application from PL/SQL code
- SQL Statement
- SQl info for Time Query
- SLQ code for sending email
- mutating trigger issue...need help
- How to Delete Multiple Stored Procedures ?
- Joins???
- sysdate
- Convert Date in SQL - Query
- wdb to sql , csv to sql
- Help - SQL Keyword Error (SQLCODE -199)
- How to Configure PSP
- Delete a Substring
- SQL select by format questioin
- Parsing Varchar2
- Import/Export script
- PL SQL: How to get subtype out of a supertype table?
- Trigger activates with change in date
- Sequence
- Oracle 8.1.7 BFILENAME and CREATE DIRECTORY
- Oracle 8.1.7 SP and IN operator
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.