• Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • Using SUBSTR with interactive SQL

    I am trying to change part of a field using the substring command in interactive SQL. To do this I entered the following: UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999 I get the error token ( was not valid. Valid tokens: = .' Obviously there is a syntax...

    GHENDER190 pointsBadges:
  • Rollback command in SQL

    Suppose user x insert values into table t1,and then update the table t1. After then he wants to increase the size of column c1. Then he wants to rollback to update values. He can do this or not? If yes then what is the right procedure?

    10111986105 pointsBadges:
  • Concentrate more than two fields together into one field in SQL

    Say I have 3 columns: 1st name, middle name and last name. How do I merge the 3 columns into one column yet separate the content with commas?

    Sammy545 pointsBadges:
  • SQL query – Unique item with latest date of entry

    Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three...

    SmurkyIS15 pointsBadges:
  • Oracle SQL and compare date

    Hello! I need help. I want to compare two dates and count how many days its between them. Example: 2006-09-22 and 2006-10-06 results: 14 days Hope for help. Thanks!

    MissNew0 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 pointsBadges:
  • Notrix formula

    I have a Notrix job which is transferring data from Notes to SQL.  I have a date field that appears on the form 03/27/2013 but comes over to SQL as 27 Mar 2011.  I haven't had too much experience with Notrix and have only done some trim formulas. I tried @Trim(@Date(FIELD)) and it brought back...

    MSNotes10 pointsBadges:
  • JDBC in SQL

    Need example to retrieve data from JDBC in SQL?

    Msatbh85 pointsBadges:
  • SQL insert error in php

    When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here's the actual code in...

    aceofdelts1,870 pointsBadges:
  • Numeric value error

    How to solve this Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

    avk86510 pointsBadges:
  • Inventory transaction using Crystal Reports Visual and SQL

    I have created a report with all parts in our warehouse with part location, qty and transaction dates. Since there are various locations with qty(or no qty) and various transaction dates linked to them, I can not max and get the info I need. I need all parts that have qty (or no qty) in their...

    AVLJACKIE5 pointsBadges:
  • Compiler

    Which compiler should I use in SQL?

    kitukisu5 pointsBadges:
  • Expression to insert value to a table column in SQL

    My CL program has RUNSQLSTM. The SQL source has some SQL statements(source is of type SQL) which inserts value to a file. I need to change the SQL to have a column(FLD1) value like this (A*B*C)/10**D. A,B,C, and D are file fields. The attributes are like this A- (15,2) B- 13 C - (13,5) D - 1 I have...

    RamvishakRamesh2,505 pointsBadges:
  • Entry Level Vendor Neutral SQL Certification

    Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks...

    MG357805 pointsBadges:
  • AS400 to Oracle query

    Can I query a Oracle database directly from AS400 using interactive SQL.Will I need to install any driver or is there a way around?

    Atti123135 pointsBadges:
  • DFU to SQL translator

    Is there a package that will allow the user to enter DFU commands and then translate to SQL and send that to the processor? The situation is that the logging program doesn't see DFU commands but does see SQL statements.

    DandyDon10 pointsBadges:
  • PLEASE HELP SQL CODE

    need some help, my code is below as follows with my questions indicated by *. SET ECHO OFF; SET FEEDBACK OFF; SET TERMOUT OFF; SET HEADING OFF; SET PAGESIZE 400; SET LINESIZE 600; SET NEWPAGE 0; SET TRUNCATE ON; ***at this time i am truncating the whole document how can i just truncate a specific...

    Alex88090 pointsBadges:
  • Debug

    How to debug an SQL Stored Procedure?

    bigT35 pointsBadges:
  • SQL SERVER

    The SQL Server mobile edition is supported on?

    siphesihle10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following