PDA

View Full Version : ANSI SQL

Pages : 1 2 3 4 5 [6] 7 8 9
  1. How to input?
  2. Data Extract then create new table
  3. can someone check this code for a nOOb
  4. How to find a record by number
  5. Need Help With A Query
  6. using convert function for date in transact sql
  7. display result in one row
  8. SQL statement "not in"
  9. Table Creation?
  10. How do i "Join" back to the same table and fields ? Please help !
  11. not a GROUP BY expression????
  12. How do you aggregate on a group?
  13. A little help, please?
  14. Need some help, hint for query
  15. Strange problem - no matching unique or primary key...
  16. Trigger for checking daterange from two columns?
  17. SQL Problem!!!
  18. left outer join
  19. SQL queries - about date
  20. Assigning FOREIGN KEY, which method is correct?
  21. conditional query
  22. Percent of columns with a certain value
  23. Ingres equivalent?
  24. Subquery in the SELECT list
  25. can somebody help my optimise my code please
  26. Printing output even though no results found
  27. Alternative to GROUP BY
  28. Want a help in Optimize a query.
  29. Order by problem
  30. delete the record i want
  31. SQL Input Data and Retrieve?(Oracle)
  32. Trouble using SELECT to retrieve NULL data from a table
  33. A little help remembering how to do make table
  34. SQL Query Question
  35. SQL Server and Oracle's CONNECT BY costruction
  36. counting distint records
  37. Working with money
  38. Comparing Tables By The First Seven Digits
  39. Help on comparing values
  40. Manipulating output
  41. Please Help!!!
  42. Using SUM
  43. Insert syntax error
  44. Create a Database
  45. UPDATE and INSERT/ADD NEW in one query?
  46. Update table from an lookup table
  47. Data Warehousing:Best way to write SP?
  48. String equivalent to SUM
  49. Newbie needs help with homework due today
  50. Query help
  51. SQL Triggers
  52. New to SQL, but Learning, Query Help
  53. Unexpected error
  54. SQL Analytic function
  55. Problem with COUNT and HAVING
  56. Selecting exclusive items (In one table, but not in another)
  57. Query Problem
  58. Query Problem
  59. Left Outer Join but right table has > 1 record
  60. count query problem
  61. join
  62. Please help - Is this even possible??
  63. Please Help!! I'm going to JOIN a mental asylum!!
  64. Registered Customers
  65. Query Help for Newbie
  66. I have a bit of a dumb question...
  67. A new SQL parser
  68. easy query for you...
  69. multi-table join problem
  70. Is Null, Is Not Null Statement
  71. SQL - Base table vs View
  72. Really confused in SQL statement
  73. Advice badly needed
  74. Parenthesis in field value
  75. Informix SQL; finding the position of a substring
  76. prompt for value
  77. Need help with this query
  78. CREATE TABLE with a DEFAULT for Microsoft Access
  79. Having trouble distilling something down to a single query
  80. Pls Help - Urgent handling "-" in query
  81. possible to move nodes in Nested Set Model?
  82. Return row even though search value is null?
  83. Update query
  84. [SELECT] question
  85. Inner Join Question
  86. Where Not Exists!?!
  87. Creating Record set using oracle procedures.
  88. Oracle SQL: Agg. Fn. Calculation
  89. Using Cursors to find value changes
  90. Running a Sql query from Crontab.
  91. select * from table, but do a look up first..?
  92. Oracle: single-row search
  93. TSQL Checkers Game
  94. Dynamic SQL - pass table and column name
  95. Now I know!
  96. SQL Checkers Game
  97. How do I connect to a diff database within a pl/sql program
  98. help!
  99. concatenate tables in sql 2000
  100. concatenate columns in sql 2000
  101. Nz syntax
  102. SQL for search access database
  103. Two SELECT statements
  104. sql query help...
  105. Probably Very Simple
  106. Replacement for MAX statement?
  107. SQL Performance Tuning
  108. Same Phone Number for all searches
  109. Sending data from a query to a table in access..is this possible???
  110. Access SQL problems using MS Jet OLEDB with ADO+VB6
  111. Programming a button control to copy data to another form?
  112. Need help with CURRENT_DATE and INTERVAL
  113. Doubt in Index
  114. MS Access 2002 SQL
  115. book on EVERYTHING in SQL
  116. SQL in Oracle 9i, merging columns
  117. integer count
  118. Access 2002...
  119. Please help!
  120. Complex Query Help.. Please :)
  121. Sorry guys I have to reask.
  122. Exclusive selection
  123. Sql Server 6.5 Service Pack help required!
  124. Dumb Newbie
  125. Image Data Type
  126. SELECT DISTINCT in multiple colums
  127. no records are displayed?
  128. sql syntax in other languages than English?
  129. How to get column titles ?
  130. argh...date problems
  131. question on join
  132. Difficult SQL
  133. Multiple Table Combination
  134. Analyze 2 Columns in 1 Table
  135. Passing Index Value
  136. SQL: NestedSet Tree, getAncestors() with level
  137. A syntex problem.....I think
  138. Check for duplicates
  139. Trouble w/ order by on a Union
  140. Help: Selecting from two tables: odd situation
  141. create temporary table in linux
  142. Help need on column reference constraint with trigger conflict
  143. Newbie help On Sql string form vb
  144. How to select 5 results only ?
  145. Semi-complicated query
  146. Answers needed for these multiple choice questions
  147. Can we speed this up?
  148. Consolidation Query
  149. Problems with Analysis Services running on Citrix client
  150. tough query help
  151. SP Version
  152. Select Where
  153. query help
  154. Looking for help with an SQL query.
  155. Need to know how to optimise an SQL statement
  156. Question about GROUP BY and Views
  157. .LST a .TXT
  158. how can i get a list of tables ?
  159. Select rows with one distinct column help
  160. In need for a solution for practical problem
  161. Null values in queries...
  162. SQL%NOTFOUND not working
  163. NewB- Selected Data transfer from tables
  164. Null record
  165. Newbie Q with SQL
  166. Subquerying
  167. How to delete all rowa in all tables of a schema in Oracle?
  168. Selecting "month/year" from table
  169. Tab-delimited format
  170. "Case insensitive" index
  171. Select stmt on Column Name that is also a system function name
  172. summarize subqueries
  173. Updating a table row, how?
  174. Placing Notes In Sql Statement
  175. Update by Key
  176. Problem with Capital Field names in db and sql statements in small letters
  177. Count for each word in a field
  178. selecting from a query
  179. How to get A list of table in SQL database ?
  180. Issue on SQL in MS SQL2000 and Access
  181. OCR Features
  182. Retrieving rows with 2 indexes
  183. 547 error: help decoding
  184. 547 error: help decoding
  185. UNION in subqueries
  186. Delete statement trouble
  187. inner join problem
  188. query optimisation question
  189. Union Sql Type: Error
  190. SQL-Additional fields
  191. Return one result from a vertical table
  192. SQL Operators
  193. Sql please help !!
  194. How to sum multiple fields together
  195. SQL Enterprise Manager - Design mode Question
  196. SQL to search with multiple criteria
  197. SQL Question
  198. Question about Max function
  199. LEFT Join with multiple tables in SQL query
  200. Db-library network communciations layer not loaded
  201. who can help me ? it is urgency .thanks
  202. Format Date
  203. sql query
  204. Simple SQL Query
  205. distinct query & a union of some kind?
  206. Any code for automatically inserting queries of first table into the second?
  207. SQL syntax problem
  208. SQL in a CL
  209. Sql (Inner Join)
  210. Urgent: How to concatenate?
  211. SQL query from web page?
  212. What is the benefits of having SQL server software?
  213. Installing Local SQL2000 Personal Edition
  214. How to some text withing a field
  215. max no. of values in WHERE ... IN clause
  216. Help with query - selecting min value
  217. database inconsistencies
  218. query by recent dates
  219. stored procedure
  220. insert into a table from another table
  221. sql headach
  222. Two tables update at the same time.
  223. inner join query help
  224. database user post extraction
  225. returning total records using count
  226. sql insert problem in asp
  227. just query
  228. Create Table Question
  229. Complex relationship
  230. "Sql" Is it possible!!
  231. error sqlcode -902
  232. need to get sth which is more than avg
  233. Copying record with non automatic primary key
  234. Combining LEFT JOIN and MAX
  235. Select query between two figures
  236. reverse pivot
  237. Use time in Sql (Problem)
  238. deleting data from database
  239. Max function
  240. Echo for SQL scripts
  241. Top Five Of Each Group
  242. Table join and sub-query optimisation?
  243. Selecting across a many to many relationship
  244. Need to Optimize the SQl Query
  245. SELECT query combining two field ids
  246. union between different databases
  247. Synchronising Access and MySQL databases
  248. DSN Connections in SQL DTS
  249. dateformat
  250. Create a Updated Form?