PDA

View Full Version : ANSI SQL

Pages : 1 2 3 [4] 5 6 7 8 9 10
  1. sub query grrrrr. help!
  2. ORA-00937 error
  3. Design Help!
  4. distinct: removing dups
  5. Combine and
  6. outer join
  7. Loading data from Mainframe to SQL-server
  8. renaming a table
  9. inner join
  10. Grouping, mins, and sums???
  11. how to ? GROUP BY?
  12. Need help with an SQL statement to get data from 2 tables
  13. How to get The Standard Query Language's general standard??
  14. count 2 value in a table
  15. calculate difference between rows (was "Sql")
  16. Any suggestions on how to revise code to accomodate order by issue
  17. [DB2] Update Field in Table A to a Field in Table B
  18. minimum and maximum in a time range (was "SQL query")
  19. Displaying the query result in one row
  20. Time Stamp Query
  21. SQL resourse
  22. calculations in a self-join (was "Query")
  23. MySQL DB Optimization
  24. Missing Values
  25. Triggers and Procedures
  26. selective update master table from another table
  27. Can't quite figure this one out... any help?
  28. speed comparison: integer - char(12)?
  29. Querying non-linked table
  30. Special Sorting of Fields with SQL
  31. Counting Unique Values?
  32. SQL Query problem
  33. problem with group by and maximum
  34. SQL Query:TEXT Data Type Operators
  35. Access returns blank results on localhost
  36. calculation values
  37. SQL - "format/input mask" in DDL
  38. Executing App with DTS, trouble with scheduling package
  39. sql text data
  40. calculation query
  41. Insert chars with line feed
  42. I need help with this sql string....('{0}', {1},'{2}', '{3}');", Chr(64 + j)
  43. Find Two Longest Serving Employees
  44. sql: GROUP BY trouble
  45. Sorting a query
  46. Create a View
  47. Trigger problem: No data found error
  48. Nasty grouping query
  49. POs and closed PO lines (was "I think this is an easy one..")
  50. Sql Query: trouble joining
  51. commas
  52. cleansing data
  53. Removing dupes (distinct like)
  54. Update method with now() function
  55. Sum by month
  56. need help using 'IN'
  57. Beginner with crosstab queries
  58. Duplicate Rows Blues
  59. Min Function Problem
  60. avoiding duplicate lines
  61. Beginner question on Altering constraints in Tables..
  62. asking help on Full Outer Join on multi-tables
  63. Number conversion
  64. Problem using SELECT statement on Access Column Name
  65. i am having an issue with my trigger code
  66. Very beginner needs help with Cobol & SQL
  67. Looking to learn SQL
  68. Calculating dynamic values for shopping cart quantity
  69. JOIN to get rows in one table that are not in the other
  70. Req help with data types/domains
  71. Need help for mysql statement. urgent
  72. "Converting numbers into Dates"
  73. replace a column with the contents of another with SQL?
  74. Joining Tables
  75. SELF JOIN help needed
  76. Help needed to generate a "sort code"
  77. Summary Of Data
  78. SQL Servers view meta data(urgent)
  79. Using C++ Builder and Database Desktop db connections
  80. Double join... kind of...
  81. Help if possible
  82. Sql Statement
  83. seperating info from a query
  84. Triggers
  85. Max Count(*) question
  86. new sql searching
  87. self-join help
  88. Describe command.
  89. Re: How To Misuse SQL's From Clause
  90. Combining info from two tables?
  91. Problem with Sum function in Access
  92. Delete to (error message)
  93. Delete more than one table
  94. SQL (Return the number of row)
  95. How to get output of sql command in columns
  96. Help with sql query
  97. Statement converting Columner to Tabular
  98. rollup data rather than numbers?
  99. query w/ case help
  100. SQL0418N when inserting with select from the same table.
  101. Foreign key
  102. Relatively easy SQL SELECT statement issues :/
  103. Import/Export
  104. Easy query help... :(
  105. Query to obtain missing number
  106. UPDATE multiple rows
  107. obtaining parameters from a combobox
  108. SQL Latest Date Query
  109. Syntax error in CONSTRAINT clause
  110. New to SQL
  111. duplicate results returned in query
  112. select into
  113. Need Query Help (with a COUNT(*) for listings) please..
  114. Special ordering
  115. Please Help
  116. Create a Updated Form?
  117. dateformat
  118. DSN Connections in SQL DTS
  119. Synchronising Access and MySQL databases
  120. union between different databases
  121. SELECT query combining two field ids
  122. Need to Optimize the SQl Query
  123. Selecting across a many to many relationship
  124. Table join and sub-query optimisation?
  125. Top Five Of Each Group
  126. Echo for SQL scripts
  127. Max function
  128. deleting data from database
  129. Use time in Sql (Problem)
  130. reverse pivot
  131. Select query between two figures
  132. Combining LEFT JOIN and MAX
  133. Copying record with non automatic primary key
  134. need to get sth which is more than avg
  135. error sqlcode -902
  136. "Sql" Is it possible!!
  137. Complex relationship
  138. Create Table Question
  139. just query
  140. sql insert problem in asp
  141. returning total records using count
  142. database user post extraction
  143. inner join query help
  144. Two tables update at the same time.
  145. sql headach
  146. insert into a table from another table
  147. stored procedure
  148. query by recent dates
  149. database inconsistencies
  150. Help with query - selecting min value
  151. max no. of values in WHERE ... IN clause
  152. How to some text withing a field
  153. Installing Local SQL2000 Personal Edition
  154. What is the benefits of having SQL server software?
  155. SQL query from web page?
  156. Urgent: How to concatenate?
  157. Sql (Inner Join)
  158. SQL in a CL
  159. SQL syntax problem
  160. Any code for automatically inserting queries of first table into the second?
  161. distinct query & a union of some kind?
  162. Simple SQL Query
  163. sql query
  164. Format Date
  165. who can help me ? it is urgency .thanks
  166. Db-library network communciations layer not loaded
  167. LEFT Join with multiple tables in SQL query
  168. Question about Max function
  169. SQL Question
  170. SQL to search with multiple criteria
  171. SQL Enterprise Manager - Design mode Question
  172. How to sum multiple fields together
  173. Sql please help !!
  174. SQL Operators
  175. Return one result from a vertical table
  176. Union Sql Type: Error
  177. query optimisation question
  178. inner join problem
  179. Delete statement trouble
  180. UNION in subqueries
  181. 547 error: help decoding
  182. 547 error: help decoding
  183. Retrieving rows with 2 indexes
  184. OCR Features
  185. Issue on SQL in MS SQL2000 and Access
  186. How to get A list of table in SQL database ?
  187. selecting from a query
  188. Count for each word in a field
  189. Problem with Capital Field names in db and sql statements in small letters
  190. Update by Key
  191. Placing Notes In Sql Statement
  192. Updating a table row, how?
  193. summarize subqueries
  194. Select stmt on Column Name that is also a system function name
  195. "Case insensitive" index
  196. Tab-delimited format
  197. Selecting "month/year" from table
  198. How to delete all rowa in all tables of a schema in Oracle?
  199. Subquerying
  200. Newbie Q with SQL
  201. Null record
  202. NewB- Selected Data transfer from tables
  203. SQL%NOTFOUND not working
  204. Null values in queries...
  205. In need for a solution for practical problem
  206. Select rows with one distinct column help
  207. how can i get a list of tables ?
  208. .LST a .TXT
  209. Question about GROUP BY and Views
  210. Need to know how to optimise an SQL statement
  211. Looking for help with an SQL query.
  212. query help
  213. Select Where
  214. SP Version
  215. tough query help
  216. Problems with Analysis Services running on Citrix client
  217. Consolidation Query
  218. Can we speed this up?
  219. Answers needed for these multiple choice questions
  220. Semi-complicated query
  221. How to select 5 results only ?
  222. Newbie help On Sql string form vb
  223. Help need on column reference constraint with trigger conflict
  224. create temporary table in linux
  225. Help: Selecting from two tables: odd situation
  226. Trouble w/ order by on a Union
  227. Check for duplicates
  228. A syntex problem.....I think
  229. SQL: NestedSet Tree, getAncestors() with level
  230. Passing Index Value
  231. Analyze 2 Columns in 1 Table
  232. Multiple Table Combination
  233. Difficult SQL
  234. question on join
  235. argh...date problems
  236. How to get column titles ?
  237. sql syntax in other languages than English?
  238. no records are displayed?
  239. SELECT DISTINCT in multiple colums
  240. Image Data Type
  241. Dumb Newbie
  242. Sql Server 6.5 Service Pack help required!
  243. Exclusive selection
  244. Sorry guys I have to reask.
  245. Complex Query Help.. Please :)
  246. Please help!
  247. Access 2002...
  248. integer count
  249. SQL in Oracle 9i, merging columns
  250. book on EVERYTHING in SQL