PDA

View Full Version : ANSI SQL

Pages : 1 [2] 3 4 5 6 7 8 9 10
  1. Noob Query Problem -This will be easy for you
  2. Selecting top date
  3. SQL - Stored procedure
  4. Selecting duplicates only
  5. How do you find Deleted D/O No.
  6. Order Products Based On Sales
  7. Help with nearest neighbour problem
  8. Sql Query for Team hierarchy
  9. Advanced SQL tutorials in Problem/Answer format
  10. reference numbers whose status is not 2 (was "SQL Newbie looking for a little help")
  11. Help needed for the following scenario
  12. SIngle Quotes
  13. simple SQL query
  14. Need a second opinion
  15. Stored Procedure trigger help
  16. select statement to replace a character in field?
  17. Count of Invoices for Each Hour
  18. Query syntax: select parent record, including number of children?
  19. Replication error
  20. Lag function
  21. need help with multi-table query
  22. Error Code 1062 and 1053
  23. query, special transpose and merge of data
  24. error creating cursor handle
  25. Join Issues
  26. external data
  27. 5 Database Queries to go with an online purchasing system :-)
  28. Problem need help
  29. maximum age
  30. table cannot have more than four row under car_id (was "hi")
  31. Complex SELECT QUERY using look-up tables
  32. Subquery Question
  33. sorting but always having specified fields come up first
  34. Convert columns into rows + construct query.
  35. "Limit to List" equivalent in SQL
  36. which field shld i use?
  37. How to change the content?
  38. Rate Table - Need Help To Display Data Horizontally
  39. backup operator
  40. Matching Debits and Credits query
  41. help with SQL queries please
  42. Combine multiple rows into one
  43. Doing a lookup between tables
  44. basic sql question
  45. join and only include rows where a value is max()?
  46. Double left joins with conditions
  47. multiple db, table, column query
  48. IN vs OR
  49. Sorting by Time
  50. Query no returning desired resluts, HELP
  51. Sql Query Help!
  52. Distinct values
  53. exists and in clause
  54. Joining multiple pks
  55. How to display rows as columns
  56. Query: inner joins on two columns.
  57. Ideal setup of tables for many categories and many sources
  58. Database work
  59. Selecting based on child row content
  60. SQL Injection
  61. Can't Seem to Figure out a Trigger...
  62. Field name in LIKE statement
  63. rewriting SQL to avoid multiple scan of a table
  64. Easy query help
  65. SQL query help
  66. select nur einen datensatz
  67. Join Query on a PK
  68. Help in using/learning SQL
  69. Help with SQL query
  70. Fixed text in SQL being truncated
  71. UPDATE using a JOIN
  72. Urgent SQL question
  73. Need help with query please
  74. Random row list
  75. Adding information into one field that depends what is in another
  76. query runs in Query Analyzer but not in Access (was "Help my query, please")
  77. Cumulative Field
  78. looking for dups SQL statement
  79. Help with SQL query is required please
  80. Displaying max values of each group in SQL
  81. list all employees that didn't take courses in 2005 (was "SQL statment")
  82. declaring primary/foreign keys in sql
  83. Selecting specific number of rows from a table
  84. Selecting multiple columns
  85. Splitting a combined field
  86. overlapping date ranges (was "SQL Query Help")
  87. ANSI Equivalent for IsNumeric()?
  88. Is this query correct
  89. Getting data from 3 tables (need help building a query)
  90. Date Conversion
  91. row with highest column A/B/C/D (was "SQL: is this possible?")
  92. Loop insert
  93. only want one record returned per card (was "Query Help - New expert-NOT")
  94. insert value 1 into customer table column stand (was "Very Basic Sql")
  95. Help with Cross-tab queries
  96. help with a group by query
  97. My data get's Ordered by default!
  98. Row-Limit per Group
  99. simple question
  100. how to ensure unique value over multiple columns
  101. Delete blank column
  102. Counting unresolved support calls based on two dates
  103. Exam Tommorrow Help me please
  104. Pivot table (was "help")
  105. the rows with max Val_1 for each Name (was "SQL Querry help")
  106. counting DONE and NOT DONE totals (was "Newbie SQL problem")
  107. One-to-one relational INSERT
  108. juniors enrolled in a class taught by I.teach (was "SQL queries....please help...")
  109. is it possible to write in one query???
  110. MAX vs COUNT - subselect
  111. directors, actors, films (was "SqlPlus query. Need some help")
  112. SQL Join and Sub Query problem
  113. Recursive data with multiple hierarchical level
  114. percentage queries.. i need it urgently THREE YEARS AGO!!!
  115. HELP w/ multiple table join on foreign keys
  116. Complex Query Problem
  117. Select Max value from prior where conditions
  118. What type of language of SQL?
  119. Views vs Stored Procedures for updating etc..
  120. SQL Syntax on an AS400
  121. Insert statements, primary keys and relationships
  122. Date Selection
  123. howto do multiple insertion ?
  124. group by help!
  125. Set Intersection Finding Only Exact Matches
  126. How does a Joined-Subquery Work After ALL Operator?
  127. timespan primary key
  128. How Can I Use a SubQuery to Sum a Column "Quantity" where subqry.item=mainqry.item?
  129. Dynamic generation of table name
  130. JOIN based on column value
  131. storing values in different tables based on data type
  132. Table optimization
  133. problem with foreign keys
  134. Problems with right outer join
  135. SubQueries - Most recent Rate from joined table
  136. duplicate rows??
  137. Should i go for MS SQL server or MySQL or PostgreSQL (was "SQL newbie")
  138. database of field trips from a daycare (was "Help with building a query")
  139. Minor Table Insert help
  140. check a table to see whether it has nothing in it (was "Help with An SQL statement!")
  141. Best query||design for table>subtable
  142. table join
  143. Column Headings in Result Sets
  144. if date_made > or = to birth_date +30
  145. multiple queries on joined table - need a better way
  146. Concat
  147. Limit amount of characters returned in query - SQL
  148. select statement
  149. selecting records using a snapshot time
  150. Good SQL books for (SQL-server, oracle, DB2, Postgress, MySQL)
  151. convert numbers in SQL
  152. SQL Question counting orderlines
  153. If statment to SQL ??
  154. xls spool file doesn't automatically link to new xls file
  155. Select table for a specific column name
  156. Really need urgent help in Insert statement
  157. concatenation / group by problem
  158. Stored Procedure problem in ActiveX Script
  159. Spool file?
  160. Query is driving me nuts!! - Subtraction problem
  161. Santa wants a day off
  162. Con Cat In Ate
  163. Another Noob question
  164. smalldatetime query
  165. Dates
  166. a few easy noob questions about tables
  167. ERD + MS Access = MySQL DB?
  168. IS NULL query problem
  169. Anyone heard of Hyperion?
  170. Help I'm a Noob - Updating a database entry.
  171. Conditional Count(*)
  172. SQL wont work
  173. Study Materials
  174. programming with PL/SQL
  175. Update Query?
  176. Can anyone suggest whey I dont get any results with this search?
  177. Select Leaf nodes of trunk (JOIN or ??)
  178. Transact SQL -- how do I use "Case"?
  179. How to Collete a database?
  180. closest to 0
  181. History Tables
  182. Joining two columns together to be searched as one
  183. minvalue and maxvalue in sequence
  184. Selecting part of data in a query
  185. More complicated use of aggregates...
  186. Get last 7 days inserted Record
  187. Aggregation against multiple date fields
  188. Query in SQLCE Doesnt Work
  189. Where Can I find system password?
  190. Spatial Data Type: PL SQL
  191. Triggers-- Help!
  192. Bulk Load
  193. Count the number of groups
  194. TOAD Export Problem
  195. Subset Problem.....
  196. stop query from running
  197. search query
  198. Display the total sum of rows found
  199. update more than 1 row
  200. SQL Statement Problem
  201. e-r tool
  202. Need basic SQL query help
  203. sql query - select ...like
  204. Searchng a Text Field with Wildcards
  205. VB to SQL
  206. I need help, please...
  207. Temporary Table
  208. Ignore Duplicates SQL Question
  209. SQL Syntax/Logic? Question
  210. twelve month array
  211. Inner joins on a table with two foreign keys
  212. Grouping pblm
  213. 3 Table Join
  214. INSERT Help!
  215. Distinct Count on joined tables
  216. please help me to correct its infinity loop(Dynamic Create Table in Stored Procedure)
  217. Avoid getting same country twice
  218. Dynamic Create Table in Stored Procedure
  219. Producing Text File
  220. query from 3 tables
  221. Simple query question? plz help
  222. age into age band
  223. Spool file without select statements appearing?
  224. SQL Separator Change
  225. SQL Query Needed
  226. Nested queries difficulty
  227. Simple, must be simple :)
  228. Need help with a TSQL Query please
  229. Index FoxPro table with ADO
  230. check's or constraints?
  231. Select-ing from variable number of tables
  232. SQL Script Error while trying access Applications within NTCSS
  233. Help with DTS for datatransfer from Oracle to SQL server
  234. dropping functions
  235. Automate query output to .txt or .csv file
  236. group by help?
  237. need sql query
  238. Join Problem
  239. Lookup table
  240. using a second table for criteria
  241. Simple query?!
  242. How to convert dates to numeric numbers
  243. NOT EXISTS problem
  244. help with one more SQL query...
  245. Problem: "joining" data from two tables
  246. sql query to substract to columns
  247. possible SQL query for this function??
  248. Setting Multiple Options for Execute
  249. How to work out this one-to-many join?
  250. select records with expiry date = current month (was "Simple SQL question...")