PDA

View Full Version : ANSI SQL

Pages : [1] 2 3 4 5 6 7 8 9 10
  1. What's the Best Table Structure for a Membership System?
  2. Pls Help to Get Result..
  3. Not sure why this sql isn't working (NOT IN)
  4. Need help in writting query
  5. Help with an sql query...
  6. aggregation problem
  7. How do I redirect output file using SPOOL
  8. Concept of this SQL query
  9. Inner Join
  10. Looking for help with an unmatched record query
  11. Count Question
  12. SQL query construction question (selecting particular records from child table)
  13. Max
  14. compare two tables records using cursour
  15. Join on 3 tables with wild card for Search
  16. If else?
  17. Help with sorting results
  18. Strange results when working out average of a count
  19. SQL Term and Example?
  20. retrieving information for many tables??
  21. Multi-Row-Update
  22. Help with a very slow SQL-Statement
  23. List 3 tables
  24. difference of two queries
  25. query to display gaps in dates
  26. how do i insert a null value from a script ?
  27. SQL Query Help (Please)
  28. aggregate of an aggregate
  29. Using count(*) in where question
  30. beginner question!
  31. ANSI syntax for joining 4 tables-am I correct?
  32. Trying to get rid of subqueries
  33. a tricky sql query
  34. How to Return Moving Differences with Grouping?
  35. max date with specific criteria from same table
  36. how to duplicate a row where tables are linked
  37. Counting values into separat columns
  38. using OR vs using Union
  39. help on a join query
  40. Question for pat phelan
  41. Trouble with querying
  42. selecting unique values problem
  43. sum of counts of same data existing in 2 different tables
  44. sum of counts of same data existing in 2 different tables
  45. 3 table outer join problem
  46. Any limits to using 'IN' with sub query?
  47. sql query help/problem
  48. How to return only 1 row
  49. Help needed with Joins
  50. Update using Corelated sub query
  51. SUM for DISTINCT rows
  52. Identical BOM's
  53. data based on unique values in another column
  54. Help needed in forming a query
  55. How can i compare smallint and int
  56. How can I create a Query based on a Table?
  57. sum of record counts provided by correlated subquery
  58. Query Top 5 item related
  59. Help with scalability design
  60. Update table from subselect openquery (SQL2K5)
  61. Need help formulating a non-equal join
  62. Help with table JOIN
  63. How do I display 2 column table as a 8 column table
  64. grouping results of group by?
  65. After combining tables, how to avoid sub queries?
  66. Trying to get two counts from same joined tables
  67. Wisegroup
  68. can DECIMAL columns be unsigned
  69. delete and update properties for primary keys? (was "nother n00ber")
  70. key constraints inline or separate? (was "primitive n00b question")
  71. Join question
  72. order of tables in a join
  73. Back Again!
  74. Newbie Question...
  75. Querying Strategies
  76. SQL conversion
  77. Getting the maximum value in a join and displaying the result as one
  78. SQL Query to order a list
  79. sql book recommendation
  80. delete query help
  81. query help
  82. Constraints in Tables
  83. Max() on JOIN subquery with extra columns
  84. Update From
  85. SQL - Multiple text values in the same field
  86. Partition By clause in ANSI SQL
  87. Calculation query
  88. SQL Join Query Syntax
  89. what column to index?
  90. How to return a fixed number of rows?
  91. Searching for logical combination of tags
  92. Update query Issue
  93. Do not want to use UNION ALL
  94. view and insert/update?
  95. Query Help
  96. increment by one while ?
  97. ANSI SQL Built-in Functions
  98. Help formulating a query
  99. the more performatic sql
  100. Copy record from Table to Table
  101. help with join query
  102. SQL Query for one field with multiple values
  103. Ansi Sql 87
  104. Sorting in UNION ALL
  105. JOIN vs Agregations
  106. NOT EXIST Is there another way?
  107. Inner Join Issue
  108. SQL Query
  109. Eliminating rows from select results
  110. Sum function with logic?
  111. SQL Counter function based on Access DB
  112. a small SQL help regrading a criteria
  113. Recursive Query or Procedure
  114. Select statement with sub-query not returning any rows
  115. Union All
  116. change datetime to date
  117. Simple SELECT * (easy one)
  118. Ansi
  119. Append Data
  120. Is there a point to not using joins?
  121. Accessing substrings
  122. is null or nvl()
  123. Getting The Latest Record
  124. Distinct & eliminate duplicate data
  125. List of cities and countries
  126. Kind of simple join question. Not sure if it's that
  127. group several rows in a SQL query
  128. Filling out missing data in subsequent records?
  129. Create row from number range
  130. Help on delete statement
  131. SQL to find if field is low values
  132. index column names in a database
  133. Join 2 SQL statements
  134. if row exists update count, else insert
  135. Substring
  136. Error converting data type varchar to float.
  137. minimum price on earliest date
  138. Calling SQL Guru's (query help needed!!)
  139. Return Values on conditions
  140. Is it possible to optimize DB by this strange way ?...
  141. Need Help on SQL statement
  142. float4
  143. Check for duplicate before insert with composite key
  144. Conditional SQL Statements?
  145. Entities
  146. Normalization
  147. Can SQL find duplicates within a "range" of numbers?
  148. select with max function
  149. Inner Join statement Vs AND operator
  150. Question on SQL experission for complicated query
  151. Problem With Distinct clause
  152. Selecting Individual Rows From Joined Table
  153. how to accumulate values in different columns ?
  154. sql and case statement
  155. union all order by
  156. A SQL query !
  157. Select , populate from diff tables based on condition
  158. Duplicate xReference Fields in 1 query ?
  159. Retrieving data from 4 tables
  160. Grouped by Using aliased names
  161. Generalisation schema Help(GIF Schema included)
  162. Use bit in SQL?
  163. Fan Trap or Multiple one-to-many joins
  164. What's wrong here? (NOT IN)
  165. Finding number of repetition T-SQL
  166. SQL Query - SELECT from multiple tables
  167. Order by clause
  168. need help with multi-table update
  169. Queries mixing two tables (beginner)
  170. SQL statement giving me trouble
  171. Noob Query Problem -This will be easy for you
  172. Selecting top date
  173. SQL - Stored procedure
  174. Selecting duplicates only
  175. How do you find Deleted D/O No.
  176. Order Products Based On Sales
  177. Help with nearest neighbour problem
  178. Sql Query for Team hierarchy
  179. Advanced SQL tutorials in Problem/Answer format
  180. reference numbers whose status is not 2 (was "SQL Newbie looking for a little help")
  181. Help needed for the following scenario
  182. SIngle Quotes
  183. simple SQL query
  184. Need a second opinion
  185. Stored Procedure trigger help
  186. select statement to replace a character in field?
  187. Count of Invoices for Each Hour
  188. Query syntax: select parent record, including number of children?
  189. Replication error
  190. Lag function
  191. need help with multi-table query
  192. Error Code 1062 and 1053
  193. query, special transpose and merge of data
  194. error creating cursor handle
  195. Join Issues
  196. external data
  197. 5 Database Queries to go with an online purchasing system :-)
  198. Problem need help
  199. maximum age
  200. table cannot have more than four row under car_id (was "hi")
  201. Complex SELECT QUERY using look-up tables
  202. Subquery Question
  203. sorting but always having specified fields come up first
  204. Convert columns into rows + construct query.
  205. "Limit to List" equivalent in SQL
  206. which field shld i use?
  207. How to change the content?
  208. Rate Table - Need Help To Display Data Horizontally
  209. backup operator
  210. Matching Debits and Credits query
  211. help with SQL queries please
  212. Combine multiple rows into one
  213. Doing a lookup between tables
  214. basic sql question
  215. join and only include rows where a value is max()?
  216. Double left joins with conditions
  217. multiple db, table, column query
  218. IN vs OR
  219. Sorting by Time
  220. Query no returning desired resluts, HELP
  221. Sql Query Help!
  222. Distinct values
  223. exists and in clause
  224. Joining multiple pks
  225. How to display rows as columns
  226. Query: inner joins on two columns.
  227. Ideal setup of tables for many categories and many sources
  228. Database work
  229. Selecting based on child row content
  230. SQL Injection
  231. Can't Seem to Figure out a Trigger...
  232. Field name in LIKE statement
  233. rewriting SQL to avoid multiple scan of a table
  234. Easy query help
  235. SQL query help
  236. select nur einen datensatz
  237. Join Query on a PK
  238. Help in using/learning SQL
  239. Help with SQL query
  240. Fixed text in SQL being truncated
  241. UPDATE using a JOIN
  242. Urgent SQL question
  243. Need help with query please
  244. Random row list
  245. Adding information into one field that depends what is in another
  246. query runs in Query Analyzer but not in Access (was "Help my query, please")
  247. Cumulative Field
  248. looking for dups SQL statement
  249. Help with SQL query is required please
  250. Displaying max values of each group in SQL