PDA

View Full Version : ANSI SQL

Pages : 1 2 [3] 4 5 6 7 8 9
  1. Simple procedure
  2. debug procedure.
  3. Removing Duplicates.
  4. Client side text handling
  5. column alias in select?
  6. Some SQL Help Please
  7. remove duplicates but display all columns
  8. help on query needed please
  9. Database triggers
  10. Sysdate
  11. about trigger ..
  12. Identify duplicate zip code + 4 digits zip
  13. Finding duplicates in the table
  14. HELP with Update with Join
  15. select from two tables where count > 1 in one of them
  16. SQL equivalent of MS Access "FIRST()" function
  17. Finding the First Record in each group
  18. need help to built one sql query
  19. Microsoft Access : I want to do Multiple Statements
  20. Pivot Tables
  21. Possible newbie SQL question. Help.
  22. ansi SQL help
  23. ASP. NET vs. PL/SQL
  24. What´s the problem?
  25. Using SUM function...help!
  26. Creating report using a loop
  27. update using subselect
  28. GROUP BY problem
  29. Dropping An Indexed Column
  30. DELETE Problem
  31. Joining multiple result sets together
  32. using parenthesis
  33. Date problem
  34. Using cursors in PL/SQL
  35. I want to search (mcse sql server 2000)'s bookshopdb's bak!
  36. Query in SQL
  37. user entered % in text field
  38. Top Nth Rows of a Group By
  39. table mutating error
  40. SQL Statement for look-up range of time by month
  41. for no reason triggers stop working
  42. SQL 7.0 Workstation Install
  43. Reading across 2 DB instances
  44. Delete with a commit statement
  45. please help me!!!! ASP GOT MAT AT ME
  46. Newbie SQL Help on Views
  47. Newbie SQL Help on Indexes
  48. Acsess --> SQL 7.0 question (IIF)
  49. HELP! insert record
  50. 4 table query returns nothig when one is empty
  51. SQL to Select Inserted Records
  52. sql query
  53. Help. sql query
  54. Dropping tables in plsql procedures
  55. Visualise SQL/PL- Rules (Datawarehouse)
  56. Help With Date
  57. Problem of max(count(*))
  58. Quick SQL Homework Help!
  59. relationship question
  60. Increment field
  61. Call Level Interface and ODBC
  62. HomeWork...Please help if you can!
  63. SQL query problem
  64. Replace OR-Operator with IN-Operator
  65. Help ... new to SQL
  66. sql join with external file
  67. Querying Fragments
  68. Date stored as Text
  69. selecting only 10 of each
  70. If-Then-Else in Where Clause???
  71. Date function thru Java
  72. add record in SQL
  73. Time conversion
  74. Update Statement
  75. SQL to obtain sum of prior payments for time frame
  76. DTS Looping
  77. truncated field?
  78. Pl/sql
  79. SQL Question
  80. output the results of a select statement into two columns
  81. sp_rename
  82. Selecting one value rather than both..
  83. No-duplicate record from query
  84. No duplicate record from joined table
  85. Puzzled by duplicates
  86. query recs created in the last 10 minutes...
  87. Another Query
  88. How to insert a numeric jscript variable into an embedded SQL statement
  89. query output format
  90. Query Question
  91. SQL and Single Cot
  92. PL/SQL Machine Model (params, return, etc)
  93. select top 3
  94. Query Question
  95. Is this SQL query possible?
  96. SQL Stored Function Needed?
  97. Concatenate Multiple Rows?
  98. select based on group criterion
  99. Object Type Queries in Oracle9i Help!
  100. Problem with "Not in " operator
  101. SQL Statements for a site like friendster.com?
  102. Returning one of two possible values
  103. Select duplicate column values
  104. Pick M or O but not both!
  105. Ignore CASE
  106. Merge Tables
  107. help in sql query
  108. Trigger fails to execute
  109. Oracle LIKE
  110. update multiple tables at the same time
  111. Newbie Procedure Problem
  112. Which is quicker
  113. Inserting into (table with trigger)
  114. Mutating tables
  115. Sql Copy/insert Statement
  116. Please help with INSERT statement!
  117. Sql Query Help pls
  118. Checking XML with a XSD in PL/SQL
  119. Error in Vantive
  120. Copy rows from a table to a new one using cursor in PL/SQL
  121. help in sql query
  122. need help with Oracle Cron Job
  123. Need help with basic exception handling
  124. What is wrong with this command?
  125. Sql Help - Select Sum
  126. how to Compare 2 tables using cursors??
  127. Need help on Function problem
  128. Need help in Functions
  129. Group By Clause Help
  130. Join Multiple Statements for view
  131. If I could explain the problem..........
  132. Another Function question
  133. SQL Query Help !!!
  134. Move Row from One table to Another
  135. Round Statement Incorrect Value
  136. How To enchance the Performance SQL stmt
  137. Primary and Foreign Keys
  138. How to get largest 3 values from 5 columns
  139. Query Help
  140. SQL Update
  141. Query within a query
  142. help very urgent
  143. Somebody understand Stored Procedure?
  144. Retruning Stored XML in a XML EXPLICIT statement
  145. procedure need help!
  146. Difference between IS and =
  147. Help with math in function
  148. Concatenating multiple rows into one field
  149. log file question
  150. A SQL query for the SQL Guru
  151. Storing function value in variable
  152. Help required in writing a query
  153. Member procedure to print own type
  154. Create date Function using SQL
  155. im beginner with sql.please help
  156. Please help!
  157. Beginner looking for help
  158. SQL for a search
  159. SQL optimizing and indexing problem
  160. Last_day
  161. constraint creation problems
  162. SQL Update Problems
  163. please help!!!!
  164. exception that does nothing?
  165. Newbie procedure problem
  166. Newbie Search Question
  167. TSQL equivalent of Oracle's 'SET echo ON'
  168. recursive SQL statement please HELP!
  169. help required in writing a query
  170. problems in variable passing from shell to procedure
  171. problem with query
  172. help date will not order by desc
  173. SQL Query Question
  174. Oracle SQL - Order BY question ??
  175. Update Join
  176. Want date entered automatically(newbie)
  177. Procedure doesn't work ...
  178. rownum and sub rownum
  179. Insert Problem
  180. Loops
  181. center sql output
  182. Sorting a query
  183. Need help with ADD_MONTHS function
  184. Does "text type" belong to SQL2 standard ?
  185. linking two databases
  186. Changing number to date
  187. SQL 9 Installation Problem
  188. SQL statement
  189. ORDER BY specific values
  190. How to compare value pair of one table with value pair of another table
  191. Triggers
  192. DBMS_DDL Error
  193. How do I use OUTPUT in a nested transaction?
  194. insert...returning / select
  195. suggestion needed in designing of table
  196. Comparing
  197. Division by Zero Error
  198. SQL Query
  199. Help - Contiguous Date Range Query
  200. Rows to Colums
  201. Trigger
  202. Procedures
  203. top 10 using select or pl/sql
  204. suspect syntax
  205. Update 1 of 2 duplicates
  206. How to transfer data from one table to another?
  207. Optimizer hints in PL/SQL cursor declaration
  208. [newbie] SQL-query with SUM() doesn't work. :(
  209. subquery + group by + max = :-(
  210. i need help with relaitonal algebra
  211. Spooling HTML directly to printer from PL/SQL
  212. Table Id's VS Compsoite Keys
  213. Export and Import table from or to text file
  214. Beginner Help Wanted With PL/SQL
  215. Plsql & Vb Error Handling
  216. SQL Query Question
  217. ORA-01422: exact fetch returns more than requested number of rows
  218. Problem Oracle with '\' and 'and'
  219. Pedigree database
  220. rownum w/ NOT IN
  221. Problem assigning defaults declaration
  222. Date arithmetic in Crystal SQL help
  223. delimited output file
  224. INTERSECT Vs. JOIN with AND operator
  225. how to get values to print horizontally?
  226. IN / EXISTS Computed for every row
  227. Member function error
  228. Need a little bit of help
  229. Need help 2
  230. Count Records Help
  231. row column repetition help
  232. Passing SMALLDATETIME into a Stored Proc
  233. set_radio_button_property built-in
  234. I can't delete records
  235. Query
  236. port Oracle OCI to MVS CLI
  237. SQL Query Question
  238. WildCard in SQL
  239. Date format
  240. How to access user files(.doc,.txt etc.)?
  241. Sumarize a column in a able
  242. Spool options
  243. Insert ... Select ... Returning !!
  244. Need assistance with SQL query
  245. Query Average Help
  246. a view in a package for oracle
  247. package to package communication
  248. Access Query: Need to return a month name instead of number in the query results
  249. SQL query yesterday eveytime ran
  250. Sql query taking long time