SQL [Archive] - Geeks Talk

PDA

View Full Version : SQL


Pages : [1] 2

  1. Date function
  2. set operator
  3. Joins
  4. sql
  5. Run a PL/SQL program
  6. Database query
  7. retrieve and display
  8. help needed in sql query
  9. printing numbers line by line
  10. pl/sql
  11. Update query using sub query
  12. sql
  13. SQL query
  14. How to insert values to child table in Toad?
  15. Explicit INNER JOIN and implicit....
  16. How to find a max number in a row of a table.
  17. sql query help
  18. sql query
  19. Sql dba resume
  20. SQL query
  21. Transactional Replication
  22. importing data
  23. insert query
  24. shrinking the master db
  25. stored procedures
  26. subquery
  27. What is the difference between self join and outer join?
  28. script
  29. sql script
  30. regarding the error log
  31. MAX(Date) Function SQL Server
  32. How to get this o/p from the sql query
  33. Sql Coding Help
  34. SQL server queries
  35. To find ratio !!!
  36. Syntax
  37. Updating million's of record.
  38. updateing the record with mapping different column
  39. updating records
  40. How can I get records in follwing format?
  41. Types of Joins
  42. How to display 3rd highest salary to 5th highest salary from emp table
  43. Different Outputs for Max() Function
  44. i want some good sql based questions with there solutions
  45. Group BY Date Range
  46. Importance of loops
  47. oracle9i
  48. hello,
  49. doubts
  50. Triggers
  51. Sequence of SQL statement processed
  52. how to create relational connection ?
  53. how to create relational connection ?
  54. sql interview questions for testig
  55. difference between self join and correlated queries
  56. Difference between LIKE and = operator
  57. Multiple SQL Servers
  58. Employee and Department Query
  59. Copy table without data
  60. Repeated Data
  61. IN operator in Oracle SQL
  62. Distinct keyword in Oracle SQL
  63. Conver MS Access table to Oracle Table
  64. Null V Nothing
  65. trigger
  66. cursor doubt-l
  67. Trigger
  68. view
  69. Move columns from different tables to one table
  70. vertical printing
  71. question
  72. Outer Join Query Example
  73. Resetting SQL Server Automatically
  74. select * from
  75. Select using having clause
  76. doubt in sql
  77. doubt in sql
  78. Oracle SQL
  79. re table creation
  80. Rerieve data from single column table
  81. SQL query..
  82. Unique key and Single Query
  83. please, help me
  84. How to alter the primary column
  85. Insert in a table
  86. Updating a View
  87. an interesting topic
  88. SQL Interview question
  89. what will be te value and why?
  90. SQL query to populate table
  91. Inserting column in the middle
  92. Getting error if insert more than 100
  93. Concept of inserting NULL
  94. Print last 3 rows in a table
  95. Difference between view and index
  96. Column for Primary Key
  97. Query to find all cars sold by salesman
  98. Oracle-SQL question
  99. Get last inserted record
  100. Retrieve last record
  101. Query to go back to one year
  102. Efficient Stored Procedure
  103. Insert record of daily data
  104. SQL, Compare then update a field after insertion
  105. Sum giving different results
  106. Set columns as not null
  107. Select specific purchase price
  108. Default value of recordset
  109. Select row by repeating
  110. merge every few rows to one
  111. Different data type for primary and foreign keys
  112. Query tune
  113. Using LIKE operator in multiple condition
  114. Is this a bug in SQL
  115. How to delete duplicate rows in a table
  116. Get 10 months data from sysdate
  117. Find previous executed SQL
  118. User function
  119. Sql query problem
  120. Simple sql questions
  121. merging two colls into one
  122. fetch rows fastly
  123. Data Base Testing using QTP 9.2.
  124. Select within select
  125. Give me the queries for.....
  126. Which is faster
  127. Store Value using loop in procedure
  128. Employee and manager name in single query
  129. How many records in output
  130. Dynamic Sql
  131. copy Constraints
  132. Hire date and salary review date
  133. Instance of Database
  134. Retrieve after roll back
  135. Run the query as Script in SQLPLUS
  136. Query to show only show the latest data
  137. Add 2 for all phone numbers
  138. Is DML statements are cursors?
  139. Migrate a .dat file to SQL database
  140. Access all tables name defined
  141. SQL Query
  142. Call function in a query
  143. DTS Package Creation
  144. Get immediate reporting managers id
  145. Error while inserting or updating
  146. what is the difference between Primary Key and Index Key ?
  147. Difference in translate and replace
  148. Execute 3 Commit 1
  149. Query to get common records
  150. Selecting Data from Two Tables
  151. Query to list all the tables in a database
  152. Store Images in Oracle Database
  153. Execution Time In SQL
  154. Can Select statement be used along with Update statement?
  155. List enames which are in italic only
  156. sql
  157. tell me the query using joins and count!
  158. extract values ascending from a particular value
  159. diffrence between delete with commit and truct table
  160. How DUAL diplays strings of length more than 1
  161. regexp in oracle 10g
  162. Need a sql query or procedure or function
  163. Please solve this problem
  164. Output without the JOIN condition. How is it possible ?
  165. Looking for query that displays Tot. no. of employes month wise
  166. Query
  167. SQL query
  168. I want to get the previous row from a table
  169. how to use paging in sql
  170. How to sort two records between two dates without using between
  171. Write a SQL to print the rows horizonatally
  172. regarding sql query
  173. sql query help...
  174. ref cursor giving error
  175. Relationship between SQL server, database and database applications
  176. Join two tables and apply group by clause
  177. System crashed after giving COMMIT command
  178. SQL DBA needed urgently
  179. Difference between VIEWS and SELECT statements
  180. employee name and salary from employee and salary table
  181. Sql
  182. I would like to lpad the first 10 numbers
  183. Extract the table name by using its column name
  184. How can I add the locations to the existing members
  185. Delete values in single a row without using DELETE keyword.
  186. Query to fetch data in matrix format
  187. How do I reverse a string with sql query only?
  188. How do I transpose Rows into Columns?
  189. Retrieve the data which are only duplicates
  190. hirerichal type database in SQL
  191. which is more suitable IN or EXIST in SQL?
  192. Where does the execution stops exactly
  193. Can we use procedures within Views
  194. Second highest number from a list of numbers
  195. What actually happens at the backend?
  196. API/Interface for implementing MRC
  197. Query
  198. Estimate the number of block accesses required
  199. Show department name and department number only once
  200. Alternative for SELECT DISTINCT to query 2 million records
  201. Best solution for this to increase the speed of execution
  202. UNION does not work in case of CLOB data type
  203. Running SQL queries through ADODC
  204. How can I display the records in specific format
  205. which one is best to display records?
  206. match string using sql query...
  207. SQL queries inside Callable Statement
  208. difference b/w "group by" and "order by" ?
  209. Difference between BETWEEN and AND query?
  210. shutdown and startup
  211. Query to find structure of a table
  212. Dyamic SQL Queries
  213. Arguments for a function
  214. Delete duplicate records without using "rowid"
  215. How to update more than one row with a different value
  216. Insert new column in the middle of a table
  217. How to get max of salary from two tables having same data
  218. Select the Employee names who held max positions
  219. Query to retrieve the text fields
  220. Get the name of 3rd most expense item
  221. How to alter a type in SQL
  222. what is trigger
  223. How to use revoke and grant in sql commands
  224. A typical problem related to SQL
  225. How can I detect changes automatically in the SQL Server Database ?
  226. Difference between the two open SQL statements
  227. Hi
  228. How to display following matrix?
  229. What is the value for MAX(SALARY)
  230. Join Query without using NOT IN subquery
  231. Display record ordered by the day of the week
  232. save some text data in SQL
  233. How to rectify this using a single update query
  234. LOBs
  235. How to find Defined key fields in a table?
  236. Grant
  237. Regarding functions in sql
  238. Query employee name who is not in dept no 30
  239. Details of emp having the 788th highest salary
  240. Insert Multiple Records at once
  241. plsql
  242. Retrieve data from emp table
  243. SQL Injection Attacks
  244. Writeing a query with HAVING clause
  245. Finding Error in PL/SQL Code
  246. Joining Tables and mapping columns
  247. Difference between VARCHAR and VARCHAR2
  248. Which trigger will fires first?
  249. Sample code on resume retrieval from database
  250. Dual Table