PDA

View Full Version : ANSI SQL

Pages : 1 2 3 4 5 6 [7] 8 9
  1. Please Help
  2. Special ordering
  3. Need Query Help (with a COUNT(*) for listings) please..
  4. select into
  5. duplicate results returned in query
  6. New to SQL
  7. Syntax error in CONSTRAINT clause
  8. SQL Latest Date Query
  9. obtaining parameters from a combobox
  10. UPDATE multiple rows
  11. Query to obtain missing number
  12. Easy query help... :(
  13. Import/Export
  14. Relatively easy SQL SELECT statement issues :/
  15. Foreign key
  16. SQL0418N when inserting with select from the same table.
  17. query w/ case help
  18. rollup data rather than numbers?
  19. Statement converting Columner to Tabular
  20. Help with sql query
  21. How to get output of sql command in columns
  22. SQL (Return the number of row)
  23. Delete more than one table
  24. Delete to (error message)
  25. Problem with Sum function in Access
  26. Combining info from two tables?
  27. Re: How To Misuse SQL's From Clause
  28. Describe command.
  29. self-join help
  30. new sql searching
  31. Max Count(*) question
  32. Triggers
  33. seperating info from a query
  34. Sql Statement
  35. Help if possible
  36. Double join... kind of...
  37. Using C++ Builder and Database Desktop db connections
  38. SQL Servers view meta data(urgent)
  39. Summary Of Data
  40. Help needed to generate a "sort code"
  41. SELF JOIN help needed
  42. Joining Tables
  43. replace a column with the contents of another with SQL?
  44. "Converting numbers into Dates"
  45. Need help for mysql statement. urgent
  46. Req help with data types/domains
  47. JOIN to get rows in one table that are not in the other
  48. Calculating dynamic values for shopping cart quantity
  49. Looking to learn SQL
  50. Very beginner needs help with Cobol & SQL
  51. i am having an issue with my trigger code
  52. Problem using SELECT statement on Access Column Name
  53. Number conversion
  54. asking help on Full Outer Join on multi-tables
  55. Beginner question on Altering constraints in Tables..
  56. avoiding duplicate lines
  57. Min Function Problem
  58. Duplicate Rows Blues
  59. Beginner with crosstab queries
  60. need help using 'IN'
  61. Sum by month
  62. Update method with now() function
  63. Removing dupes (distinct like)
  64. cleansing data
  65. commas
  66. Sql Query: trouble joining
  67. POs and closed PO lines (was "I think this is an easy one..")
  68. Nasty grouping query
  69. Trigger problem: No data found error
  70. Create a View
  71. Sorting a query
  72. sql: GROUP BY trouble
  73. Find Two Longest Serving Employees
  74. I need help with this sql string....('{0}', {1},'{2}', '{3}');", Chr(64 + j)
  75. Insert chars with line feed
  76. calculation query
  77. sql text data
  78. Executing App with DTS, trouble with scheduling package
  79. SQL - "format/input mask" in DDL
  80. calculation values
  81. Access returns blank results on localhost
  82. SQL Query:TEXT Data Type Operators
  83. problem with group by and maximum
  84. SQL Query problem
  85. Counting Unique Values?
  86. Special Sorting of Fields with SQL
  87. Querying non-linked table
  88. speed comparison: integer - char(12)?
  89. Can't quite figure this one out... any help?
  90. selective update master table from another table
  91. Triggers and Procedures
  92. Missing Values
  93. MySQL DB Optimization
  94. calculations in a self-join (was "Query")
  95. SQL resourse
  96. Time Stamp Query
  97. Displaying the query result in one row
  98. minimum and maximum in a time range (was "SQL query")
  99. [DB2] Update Field in Table A to a Field in Table B
  100. Any suggestions on how to revise code to accomodate order by issue
  101. calculate difference between rows (was "Sql")
  102. count 2 value in a table
  103. How to get The Standard Query Language's general standard??
  104. Need help with an SQL statement to get data from 2 tables
  105. how to ? GROUP BY?
  106. Grouping, mins, and sums???
  107. inner join
  108. renaming a table
  109. Loading data from Mainframe to SQL-server
  110. outer join
  111. Combine and
  112. distinct: removing dups
  113. Design Help!
  114. ORA-00937 error
  115. sub query grrrrr. help!
  116. MS-SQL SQL to Access SQL
  117. Getting records that only exist once.
  118. 'tables' of data
  119. Analysis Manager Profiler
  120. inner join problem
  121. GROUP BY rule holding me up - HELP!
  122. differenct between 2 select statments
  123. Images...Help!
  124. Convert datetime to seconds
  125. comparing long varchar to char problems
  126. SQL Query...
  127. Complex Query or just me?
  128. Calculating movement
  129. Investigate Unknown database file type?
  130. can somebody please help me with my query?
  131. PL/SQL help - split an address
  132. how to increment an integer
  133. Delete duplicate records in table
  134. A simple varchar comparison
  135. problem when addin an extra field to a select
  136. Deriving data from nothing?
  137. automatically send a notice after 6 months (was "Date Question")
  138. Email passwords
  139. Drop Relationships
  140. A way to "SELECT constraints FROM table"
  141. Join tables and exclude records...
  142. trouble counting SUM GROUPed BY
  143. using wildcard character in select statement
  144. Recording the time
  145. help with update query
  146. Help please! Problem with a particular date in SQL command?
  147. Pivot Tables using SQL
  148. heading size
  149. Like Statement SQL Suery
  150. Novice SQL questions
  151. line numbering in result set
  152. Comparing two tables with different fields
  153. exclude a field from a wildcard search (was "A simple question! (heeelp)")
  154. Multiple rows into one query result row...
  155. outer join operation?
  156. left join problem
  157. insert date problem
  158. Performance Q's
  159. field in a table that stores my IN condition (was "In")
  160. customers in 2003, not 2004 (was "Help with (probably) simple query")
  161. select max(count of rows) (was "SQL")
  162. 4 queries into 1 query
  163. Can't Use Distinct here!
  164. Repeated Value
  165. Online SQL reference
  166. Joining Two tables
  167. Dynamic or Static SQL exact definition...
  168. Left outer join problem
  169. High Light Words in Query
  170. date...
  171. need a query to join 3 tables
  172. Good resource ?
  173. Sql Error, Why?
  174. BETWEEN statement
  175. get 5 rows from 2 unrelated tables (was "Complicated sql query.... need help badly")
  176. Count in Empty RecordSet and BOF/EOF
  177. Working With Multiple Queries
  178. SQL Statements and Data Types
  179. query result to xml file
  180. Correlated SUB Queries?
  181. record deletion problem
  182. SQL parcing
  183. Update with case
  184. SQL - conditional join (?)
  185. SQL Left join with select criteria
  186. Delete across tables
  187. Select one if active else another
  188. Searching unreleated tables
  189. three table not exists problem (was "I need help!")
  190. Determining Indirect Bus routes: SQL problem statement
  191. Listing rows "missing" information?
  192. two FKs to same description table (was "I don't know how to word this title?? :)"
  193. Unique SQL issue using a wildcard in my where statement
  194. Construct a query.
  195. Allow space in data
  196. Query and textbox difficulty.
  197. SQL's GROUPBY logic
  198. unequal fields in one and two tables (was "simple query: but i cant seem to get it")
  199. Question about Aliasing?
  200. text and numbers
  201. max(tag) for pair of matched rows (was "Need help on query")
  202. two highest and three lowest salaries (was "Query")
  203. Help with sorting strings...
  204. why we can't assign an SQL query to a variable?
  205. Help with HOUR() query
  206. SQL help
  207. construct hierarchy
  208. Need SQL Performance Advice (Scenario Given)
  209. Need a Help on Query
  210. Running a sql to find blanks or empty space in database
  211. How to enter this command line sql statement...???
  212. Select Distinct Record
  213. get expiration date from next effective date
  214. sql selecting data using user selected date range
  215. minimum number of Field G where Field K is 7 (was "Help for an sql-command")
  216. Query construction
  217. Nesting select statement inside delete
  218. Manipulating Date Functions
  219. comparing 2 tables & writing data to 3rd table
  220. Combine colunmn
  221. how to get started on homework assignment (was "SQL Help")
  222. Convert columns into rows + construct query.
  223. Rounding up in SQL
  224. select projects where module_code not in allocate table (was "sql query help")
  225. Aggregate Function
  226. AND and OR in WHERE clause returning too many results
  227. Creating a new Table from others.
  228. Calculating a percentage in a query
  229. Same Records
  230. Max(Date) and Calculated Fields
  231. what is the query for getting first 10 rows of a column
  232. What's wrong with this query
  233. Problem with DISTINCT
  234. Problems with "search engine" query
  235. having clause returns no results?
  236. calculation on the fields
  237. using self join and non-equijoin
  238. Update the table
  239. students who have not taken a course (was "SQL Question")
  240. course that employees have not taken (was "SQL Question")
  241. employee hours spent on a project (was "Another SQL question I'm afraid")
  242. Two table SELECT statement
  243. sort by availability, priority and first request
  244. Displaying user specific information
  245. insert special character
  246. select all unik groups
  247. "distinct" query-want to retrieve all columns!
  248. howto use something like 'ILIKE'
  249. Need to tie transactions to months... not sure how.
  250. Want to pass parameter value back to Korn Shell