PDA

View Full Version : ANSI SQL

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