• How to create monthly attendance report?

    TABLE I HAVE: Code Name AttendanceDate Status ---- ---- -------------- ------ A001 Abc Jan-01-2013 Present B001 Xyz Jan-01-2013 Present A001 Abc Jan-02-2013 Absent B001 Xyz Jan-02-2013 Late A001 Abc Jan-03-2013 Late Expecting below output with AVG attendance of month. Jan, 2013 Code Name 1 2 3 .....

    Sri100815 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:
  • Can I load data using SQLLDR into an in-memory table?

    Can I load data using SQLLDR into an in-memory table and is this the best way? Thanks so much.

    rG1234565 pointsBadges:
  • Dynamic SQL in RPGLE

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

    davidgrant5 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.

    ITKE434,705 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!

    ITKE434,705 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...

    ITKE434,705 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.

    ITKE434,705 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!

    ITKE434,705 pointsBadges:
  • Needed help with SQL query involving password column in a table

    Hi, I have a requirement like I need to create a table with password column which should have any of the numbers between 0-9, any special symbols, alphabets. It should contain all the three combination. If the user try to insert missing any one should throw inserting error.

    vinu54615 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.

    ITKE434,705 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:

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