PDA

View Full Version : ANSI SQL


Pages : 1 2 3 4 5 6 7 8 [9]

  1. Select Max value from prior where conditions
  2. Complex Query Problem
  3. HELP w/ multiple table join on foreign keys
  4. percentage queries..please help ..i need it urgently in 1 hour
  5. Recursive data with multiple hierarchical level
  6. SQL Join and Sub Query problem
  7. directors, actors, films (was "SqlPlus query. Need some help")
  8. MAX vs COUNT - subselect
  9. is it possible to write in one query???
  10. juniors enrolled in a class taught by I.teach (was "SQL queries....please help...")
  11. One-to-one relational INSERT
  12. counting DONE and NOT DONE totals (was "Newbie SQL problem")
  13. the rows with max Val_1 for each Name (was "SQL Querry help")
  14. Pivot table (was "help")
  15. Exam Tommorrow Help me please
  16. Counting unresolved support calls based on two dates
  17. Delete blank column
  18. how to ensure unique value over multiple columns
  19. simple question
  20. Row-Limit per Group
  21. My data get's Ordered by default!
  22. help with a group by query
  23. Help with Cross-tab queries
  24. insert value 1 into customer table column stand (was "Very Basic Sql")
  25. only want one record returned per card (was "Query Help - New expert-NOT")
  26. Loop insert
  27. row with highest column A/B/C/D (was "SQL: is this possible?")
  28. Date Conversion
  29. Getting data from 3 tables (need help building a query)
  30. Is this query correct
  31. ANSI Equivalent for IsNumeric()?
  32. Splitting a combined field
  33. Selecting multiple columns
  34. Selecting specific number of rows from a table
  35. declaring primary/foreign keys in sql
  36. list all employees that didn't take courses in 2005 (was "SQL statment")
  37. Displaying max values of each group in SQL
  38. Help with SQL query is required please
  39. looking for dups SQL statement
  40. Cumulative Field
  41. query runs in Query Analyzer but not in Access (was "Help my query, please")
  42. Adding information into one field that depends what is in another
  43. Random row list
  44. Need help with query please
  45. Urgent SQL question
  46. UPDATE using a JOIN
  47. Fixed text in SQL being truncated
  48. Help with SQL query
  49. Help in using/learning SQL
  50. Join Query on a PK
  51. select nur einen datensatz
  52. SQL query help
  53. Easy query help
  54. rewriting SQL to avoid multiple scan of a table
  55. Field name in LIKE statement
  56. Can't Seem to Figure out a Trigger...
  57. SQL Injection
  58. Selecting based on child row content
  59. Database work
  60. Ideal setup of tables for many categories and many sources
  61. Query: inner joins on two columns.
  62. How to display rows as columns
  63. Joining multiple pks
  64. exists and in clause
  65. Distinct values
  66. Sql Query Help!
  67. Query no returning desired resluts, HELP
  68. Sorting by Time
  69. IN vs OR
  70. multiple db, table, column query
  71. Double left joins with conditions
  72. join and only include rows where a value is max()?
  73. basic sql question
  74. Doing a lookup between tables
  75. Combine multiple rows into one
  76. help with SQL queries please
  77. Matching Debits and Credits query
  78. backup operator
  79. Rate Table - Need Help To Display Data Horizontally
  80. How to change the content?
  81. which field shld i use?
  82. "Limit to List" equivalent in SQL
  83. sorting but always having specified fields come up first
  84. Subquery Question
  85. Complex SELECT QUERY using look-up tables
  86. table cannot have more than four row under car_id (was "hi")
  87. maximum age
  88. Problem need help
  89. 5 Database Queries to go with an online purchasing system :-)
  90. external data
  91. Join Issues
  92. error creating cursor handle
  93. query, special transpose and merge of data
  94. Error Code 1062 and 1053
  95. need help with multi-table query
  96. Lag function
  97. Replication error
  98. Query syntax: select parent record, including number of children?
  99. Count of Invoices for Each Hour
  100. select statement to replace a character in field?
  101. Stored Procedure trigger help
  102. Need a second opinion
  103. simple SQL query
  104. SIngle Quotes
  105. Help needed for the following scenario
  106. reference numbers whose status is not 2 (was "SQL Newbie looking for a little help")
  107. Advanced SQL tutorials in Problem/Answer format
  108. Sql Query for Team hierarchy
  109. Help with nearest neighbour problem
  110. Order Products Based On Sales
  111. How do you find Deleted D/O No.
  112. Selecting duplicates only
  113. SQL - Stored procedure
  114. Selecting top date
  115. Noob Query Problem -This will be easy for you
  116. SQL statement giving me trouble
  117. Queries mixing two tables (beginner)
  118. need help with multi-table update
  119. Order by clause
  120. SQL Query - SELECT from multiple tables
  121. Finding number of repetition T-SQL
  122. What's wrong here? (NOT IN)
  123. Fan Trap or Multiple one-to-many joins
  124. Use bit in SQL?
  125. Generalisation schema Help(GIF Schema included)
  126. Grouped by Using aliased names
  127. Retrieving data from 4 tables
  128. Duplicate xReference Fields in 1 query ?
  129. Select , populate from diff tables based on condition
  130. A SQL query !
  131. union all order by
  132. sql and case statement
  133. how to accumulate values in different columns ?
  134. Selecting Individual Rows From Joined Table
  135. Problem With Distinct clause
  136. Question on SQL experission for complicated query
  137. Inner Join statement Vs AND operator
  138. select with max function
  139. Can SQL find duplicates within a "range" of numbers?
  140. Normalization
  141. Entities
  142. Conditional SQL Statements?
  143. Check for duplicate before insert with composite key
  144. float4
  145. Need Help on SQL statement
  146. Is it possible to optimize DB by this strange way ?...
  147. Return Values on conditions
  148. Calling SQL Guru's (query help needed!!)
  149. minimum price on earliest date
  150. Error converting data type varchar to float.
  151. Substring
  152. if row exists update count, else insert
  153. Join 2 SQL statements
  154. index column names in a database
  155. SQL to find if field is low values
  156. Help on delete statement
  157. Create row from number range
  158. Filling out missing data in subsequent records?
  159. group several rows in a SQL query
  160. Kind of simple join question. Not sure if it's that
  161. List of cities and countries
  162. Distinct & eliminate duplicate data
  163. Getting The Latest Record
  164. is null or nvl()
  165. Accessing substrings
  166. Is there a point to not using joins?
  167. Append Data
  168. Ansi
  169. Simple SELECT * (easy one)
  170. change datetime to date
  171. Union All
  172. Select statement with sub-query not returning any rows
  173. Recursive Query or Procedure
  174. a small SQL help regrading a criteria
  175. SQL Counter function based on Access DB
  176. Sum function with logic?
  177. Eliminating rows from select results
  178. SQL Query
  179. Inner Join Issue
  180. NOT EXIST Is there another way?
  181. JOIN vs Agregations
  182. Sorting in UNION ALL
  183. Ansi Sql 87
  184. SQL Query for one field with multiple values
  185. help with join query
  186. Copy record from Table to Table
  187. the more performatic sql
  188. Help formulating a query
  189. ANSI SQL Built-in Functions
  190. increment by one while ?
  191. Query Help
  192. view and insert/update?
  193. Do not want to use UNION ALL
  194. Update query Issue
  195. Searching for logical combination of tags
  196. which is faster?
  197. How to return a fixed number of rows?
  198. what column to index?
  199. SQL Join Query Syntax
  200. Calculation query
  201. Partition By clause in ANSI SQL
  202. SQL - Multiple text values in the same field
  203. Update From
  204. ANSI SQL Porting
  205. Max() on JOIN subquery with extra columns
  206. Constraints in Tables