• SQL Primary key and surrogate key

    When surrogate key is generated automatically, then why is a primary key required?

    Lavanya925 pointsBadges:
  • How to get nth highest salary using SQL/400 query

    Hi, How can I get nth highest salary from a PF named EMP having two columns EMPID and ESAL need to retrieve nth highest salary using SQL/400 query. Here N may be first, second,third any no.  Thanks!

    6r1,850 pointsBadges:
  • Dynamic SQL in RPGLE

    How can I build a dynamic SQL statement for input from a screen file?

    davidgrant10 pointsBadges:
  • Oracle SQL: Retrieve data for previous week

    I am trying to retrieve data for the previous week. I need to get the previous week starting on Monday and ending on Sunday. How can I retrieve the data from Monday to Sunday? For example, today is 10-Aug-2016. So, I need details from 1-Aug-2016 to 5-Aug-2016 as week day, and 6-Aug-2016 to...

    rajeshgudla5 pointsBadges:
  • SQL on multi-membered file without overriding

    How to query on a file and retrieve data from any of the members of the file without overriding to any of them?

    vishwaraja5 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • SQL database rollback query

    How do I roll back in case the database changes all data to the same information?

    twatonny015 pointsBadges:
  • Rename SQL database table

    For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.

    ITKE1,048,075 pointsBadges:
  • Getting a missing expression error when inserting from another table

    INSERT INTO dst_case1 (email) values  SELECT (email_addr) FROM siebel.S_CONTACT@TCCP.TMS.TOYOTA.COM where dst_case1.customer_id=siebel.S_CONTACT@TCC

    paramu775 pointsBadges:
  • Compare three SQL Server columns

    I have 3 tables table1 has the column id1 with three values in it '1','2','3' and table2 has column id2 with three values '3','4','5' and table3 has column id3 with three values '5','6','7'. How do I join all the three tables, and I also want the null value to be displayed. Please go through the...

    harish978920 pointsBadges:
  • Problem with character alignment on output or retrieval of variables

    We have an issue we have never seen before but I'm sure happens all the time. We have a DDS screen where the character's are shown as follows:- RETAIL LOGISTICS                     : £99.00 RETAIL FREIGHT                         :£120.00...

    Sxlad200145 pointsBadges:
  • Server settings incorrect when scheduling Crystal Report on SQL 2014

    Getting the following error message when scheduling crystal report on SQL 2014. Failed: 450 : Report Engine : Wrong number of arguments or invalid  property assignment If I generate the report directly in Crystal it is correct - no problems.

    myann590305 pointsBadges:
  • Avoid read locks on SQL database

    For my SQL database, how can I avoid read locks? Should I use a SQL statement for this? Thank you!

    ITKE1,048,075 pointsBadges:
  • INSERT two SQL tables into new table

    I have two SQL tables and they're both pretty large. But now I have to combine all of their column names into a new table and, for some reason, I don't have permission to click on each table and choose CREATE to SCRIPT. So how can I go about doing this? Basically, how can I use INSERT both tables...

    ITKE1,048,075 pointsBadges:
  • How to check if SQL row exists using PHP?

    How can I check if a SQL row exists using PHP? I'm currently using MySQL. Could I use PDO (PHP data object) to do this? Thank you so much.

    ITKE1,048,075 pointsBadges:
  • List Microsoft Access database tables using SQL

    Would there possibly be a way to list all of my tables in a Microsoft Access database using SQL? I know how to do it in SQL Server but not sure of the command in Access. Thanks!

    ITKE1,048,075 pointsBadges:
  • Convert hexadecimals to decimals in Oracle SQL

    For Oracle SQL, can I convert hexadecimals to decimals (and possibly back again if need be)? I appreciate the help available.

    ITKE1,048,075 pointsBadges:
  • Can two foreign keys reference the same primary key that is team table and fextures table having team a and team b referencing the team table primary

    Can two foreign keys reference the same primary key on another table. That I have team table attributes (Team_id, Team_name, Team_captain) and fixtures table having this attributes (Fixtures_id, fixture_time, fixture_date, fixture_venue, 1team_id, 2team_id). My question is this: Is it possible for...

    jupake15 pointsBadges:
  • PowerBuilder 11 in SQL 2008

    We are seeing performance issues with our PB 11 app after SQL 2005 DB was migrated to SQL 2008. We did not change any code just the connection profile. From: [Profile APP] DBMS = SNC SQL Native Client(OLE DB) Database=database UserId= DatabasePassword= LogPassword= ServerName=SQLServerName LogId=...

    Lstadler15 pointsBadges:
  • Add comment to SQL code in MySQL

    One of my co-workers sent me a SQL code and I need to add a comment to it. Is there a way to do that? This is currently for MySQL. Thank you so much.

    ITKE1,048,075 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.

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

Following