PDA

View Full Version : ANSI SQL

Pages : 1 2 3 4 5 6 7 [8] 9
  1. select from 2 table
  2. PL/SQL call function from trigger
  3. Self join?? Not exisits??
  4. relational algebra
  5. How to find specific orders from a list of products
  6. Join 2 tables by referencing columns with data
  7. Problem with join...
  8. Exporting results into Excel
  9. check if table exist
  10. max date
  11. How to find patterns in numbers
  12. Is there a faster way...?
  13. Adding String data
  14. Subselects and UNION
  15. How do I select repeated number??
  16. SQL syntax when working with a lot of SQL?
  17. select employee associated with max date (was "Need some SQL Help")
  18. overlapping date ranges (was "SQL Query Help")
  19. Basic SQL Query Problem
  20. Grid/table editing icons
  21. How to get the first record in a parent-child data?
  22. parent and children items in query??
  23. Intervals Over Time
  24. finding records with duplicate data
  25. how i add order field in result query
  26. Data for a particular item for maximum purchase date
  27. Max number in subquery...
  28. If Then Else??
  29. record values
  30. translate two codes (was "Sql Join Query Help")
  31. contains this but not that...query
  32. SQL - Updating records in a one-to-many relationship
  33. sql based on text box
  34. Outputting blank values instead of the actual
  35. select 1 random record in top 100 ??
  36. matching dates via checkboxes (was "SQL Query")
  37. Select closest match query
  38. LEFT/RIGHT JOIN not working....
  39. Can this be done in one query?
  40. how to select Max value in table 1 < value in table 2
  41. Advanced query...
  42. Rationale of OVERLAPS
  43. Need Advise On My SQL Statement
  44. Delete a user after 10 days? (reference to php forum)
  45. Count Rows From Two Tables
  46. How to use Order By
  47. query for same fields from two tables
  48. query using count and order by
  49. subtract total vacation days taken from allowance (was "Newbie seeking help")
  50. Aggregates in Multiple Table Joins
  51. sorting problem
  52. get row for each unique name
  53. Joining an archive table to a current table
  54. Changing the max characters attribute!
  55. Subqueries
  56. Query Optimization Books & links needed
  57. union two columns? it's that possible?
  58. HELP! 2 tables into 1 long table.
  59. "order by" on a value associated with a foreign key
  60. how to check varchar2 as a date
  61. Format output of numbers
  62. SQl calculation error in ASP.
  63. counting aging groups
  64. Table Limit Exceeded
  65. Weird UNION artefact
  66. Embedded SQL programming
  67. Query to get latest versions of items
  68. Joining multiple rows from a single table
  69. Create Oracle DMP file in SQL
  70. where not exists
  71. Need help truncating column data
  72. I Need Help in Creating a Query
  73. Insert... Where?
  74. sql:is-constant Alternatives
  75. Union results not what expected
  76. Indexes (The Basics)
  77. Escaping the Apostrophy
  78. users who have visited New York and Miami (was "Help on query")
  79. Project Hours and Totals
  80. concantonation
  81. Combining 2 SQL Select statements
  82. unknown error source
  83. Dynamic SQL or Stored procedure?
  84. SQL Server query
  85. union select tuning: what's the format for a database function with union select
  86. Union problem (how to combine the field with different data type)
  87. Dynamic query, variable columns returned
  88. Simple Query Takes 10 Seconds To Execute
  89. Postcode Midpoints
  90. complex query - 2 tables
  91. How to join two tables?
  92. T-SQL Inner Join with where criterion?
  93. Multiple records with the same value in one field
  94. SELECT COUNT DISTINCT problem
  95. return Customer even if no match in Contract (was "Help with simple sql")
  96. help with an SQL query and group by/sum
  97. Help divvying up query result into seperate tables
  98. How to Get Field Data Type
  99. Building classes
  100. Group by question
  101. WHERE clause fails in multiple joined and grouped CF query
  102. Need help with count/matching query
  103. ORDER BY - query
  104. creating table from antother user table
  105. Transforming relational tables
  106. Update Multiple records from one date field
  107. GROUP BY date
  108. multiple values query
  109. Problems using set operators
  110. multi-db web app
  111. Modifying Display Results
  112. Modifying Display Results Part II
  113. Modify Display Results Take II
  114. Modify Display Results III
  115. Help
  116. sending multiple mails
  117. recursive Query/hierarchical query
  118. select records with expiry date = current month (was "Simple SQL question...")
  119. How to work out this one-to-many join?
  120. Setting Multiple Options for Execute
  121. possible SQL query for this function??
  122. sql query to substract to columns
  123. Problem: "joining" data from two tables
  124. help with one more SQL query...
  125. NOT EXISTS problem
  126. How to convert dates to numeric numbers
  127. Simple query?!
  128. using a second table for criteria
  129. Lookup table
  130. Join Problem
  131. need sql query
  132. group by help?
  133. Automate query output to .txt or .csv file
  134. dropping functions
  135. Help with DTS for datatransfer from Oracle to SQL server
  136. SQL Script Error while trying access Applications within NTCSS
  137. Select-ing from variable number of tables
  138. check's or constraints?
  139. Index FoxPro table with ADO
  140. Need help with a TSQL Query please
  141. Simple, must be simple :)
  142. Nested queries difficulty
  143. SQL Query Needed
  144. SQL Separator Change
  145. Spool file without select statements appearing?
  146. age into age band
  147. Simple query question? plz help
  148. query from 3 tables
  149. Producing Text File
  150. Dynamic Create Table in Stored Procedure
  151. Avoid getting same country twice
  152. please help me to correct its infinity loop(Dynamic Create Table in Stored Procedure)
  153. Distinct Count on joined tables
  154. INSERT Help!
  155. 3 Table Join
  156. Grouping pblm
  157. Inner joins on a table with two foreign keys
  158. twelve month array
  159. SQL Syntax/Logic? Question
  160. Ignore Duplicates SQL Question
  161. Temporary Table
  162. I need help, please...
  163. VB to SQL
  164. Searchng a Text Field with Wildcards
  165. sql query - select ...like
  166. Need basic SQL query help
  167. e-r tool
  168. SQL Statement Problem
  169. update more than 1 row
  170. Display the total sum of rows found
  171. search query
  172. stop query from running
  173. Subset Problem.....
  174. TOAD Export Problem
  175. Count the number of groups
  176. Bulk Load
  177. Triggers-- Help!
  178. Spatial Data Type: PL SQL
  179. Where Can I find system password?
  180. Query in SQLCE Doesnt Work
  181. Aggregation against multiple date fields
  182. Get last 7 days inserted Record
  183. More complicated use of aggregates...
  184. Selecting part of data in a query
  185. minvalue and maxvalue in sequence
  186. Joining two columns together to be searched as one
  187. History Tables
  188. closest to 0
  189. How to Collete a database?
  190. Transact SQL -- how do I use "Case"?
  191. Select Leaf nodes of trunk (JOIN or ??)
  192. Can anyone suggest whey I dont get any results with this search?
  193. Update Query?
  194. programming with PL/SQL
  195. Study Materials
  196. SQL wont work
  197. Conditional Count(*)
  198. Help I'm a Noob - Updating a database entry.
  199. Anyone heard of Hyperion?
  200. IS NULL query problem
  201. ERD + MS Access = MySQL DB?
  202. a few easy noob questions about tables
  203. Dates
  204. smalldatetime query
  205. Another Noob question
  206. Con Cat In Ate
  207. Santa wants a day off
  208. Query is driving me nuts!! - Subtraction problem
  209. Spool file?
  210. Stored Procedure problem in ActiveX Script
  211. concatenation / group by problem
  212. Really need urgent help in Insert statement
  213. Select table for a specific column name
  214. xls spool file doesn't automatically link to new xls file
  215. If statment to SQL ??
  216. SQL Question counting orderlines
  217. convert numbers in SQL
  218. Good SQL books for (SQL-server, oracle, DB2, Postgress, MySQL)
  219. selecting records using a snapshot time
  220. select statement
  221. Limit amount of characters returned in query - SQL
  222. Concat
  223. multiple queries on joined table - need a better way
  224. if date_made > or = to birth_date +30
  225. Column Headings in Result Sets
  226. table join
  227. Best query||design for table>subtable
  228. check a table to see whether it has nothing in it (was "Help with An SQL statement!")
  229. Minor Table Insert help
  230. database of field trips from a daycare (was "Help with building a query")
  231. Should i go for MS SQL server or MySQL or PostgreSQL (was "SQL newbie")
  232. duplicate rows??
  233. SubQueries - Most recent Rate from joined table
  234. Problems with right outer join
  235. problem with foreign keys
  236. Table optimization
  237. storing values in different tables based on data type
  238. JOIN based on column value
  239. Dynamic generation of table name
  240. How Can I Use a SubQuery to Sum a Column "Quantity" where subqry.item=mainqry.item?
  241. timespan primary key
  242. How does a Joined-Subquery Work After ALL Operator?
  243. Set Intersection Finding Only Exact Matches
  244. group by help!
  245. howto do multiple insertion ?
  246. Date Selection
  247. Insert statements, primary keys and relationships
  248. SQL Syntax on an AS400
  249. Views vs Stored Procedures for updating etc..
  250. What type of language of SQL?