• What is the right way to write this SQL Query?

    I keep getting SYNTAX errors when I try to write this query, what is the proper way to write this query? Query question and table information is below. Return the last name and GPA of the top ten students by Cumulative GPA for students that were enrolled in at least one class during January 1,...

    dhay335 pointsBadges:
  • How do SQL related to this program?

    Can anyone tell me how SQL is related to my program?

    nlhabal5 pointsBadges:
  • SQL: Storing data in a column

    Sir, I want to know that in a table there are three columns like A, B, C. And I want to store the data on only A, B. When I insert the data, it automatically puts the result in C.

    Raju12345 pointsBadges:
  • Logical File key not working

    I am creating a new logical over a physical file. Very basic. Just one key field. It is a character file as the key. R RUB04000 PFILE(RUB0400F) K TRALER. After I create the logical file successfully and check the records, the records are NOT in the sequence as defined in the logical file DDS. I...

    Philcards15 pointsBadges:
  • Access SQL: Records from the Vendors table

    For Access SQL, how do I save records from a vendor's table

    NikiaBainton5 pointsBadges:
  • SQL query for descending order

    How do I input only each product’s name and sort them alphabetically (in descending order from Z-A)?

    ProfRockhill5 pointsBadges:
  • Oracle SQL script to deactivate customers records with possible multiple debt some paid some not paid

    I want to write a Oracle SQL script that will only deactivate a customer record with no outstanding debt.

    lindadawes5 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL: In responsiblity wise last 5 transactions details request as on 31.03.2016

    AS per audit review request: All responsibility wise AP, AR, GL, CM , FA , PO, Inv last 5 transactions taken from the SQL as given date for 31.03.2016.  Please help on our request.

    Thillainathan5 pointsBadges:
  • SELECT hex in SQL shows error

    I am a python student. this instruction: SELECT hex(User.name || Course.title || Member.role ) AS X FROM User JOIN Member JOIN Course ON User.id = Member.user_id AND Member.course_id = Course.id ORDER BY X When I run it shows invalid syntax. I am taking a python course but I know very little about...

    cmorenme5 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:
  • SQL query for top 5 sales

    I want a query through which I can get a record of last one year sales. And it should show top 5 records for every day.

    atifmushtaq5 pointsBadges:
  • TMS configuration during migration to HEC

    Hi all, We are migrating to HANA Enabled cloud from On-Premise landscape. Current landscape is D->Q->R->P After phase two, R and D will be on HEC and rest on-premise. Trans directory is set as D. OS/DB will be changed to Linux/Sybase from Windows/SQL. Please let me know if TMS...

    BASIS125 pointsBadges:
  • How to left or right justifying a text file

    Hello programmers. I am using SQL to create a table from stored procedures and then streamwriter in VB.NET to create a text file based on the SQL table. Where and how do I control the right or left justification of the records in the text file? Thx.

    Ilfoprog50 pointsBadges:
  • How can I start my IT career?

    I am certified as ISTQB FL but I have zero experience and no knowledge about programming language but I am beginning in SQL. What other skills and IT knowledge to start my career?

    Ahmed12345675 pointsBadges:
  • Oracle: Count on only one table within select

    I have the following SQL and want to add to the query a count of records for each of the tables selected out of the user_tables, basically count(*). I've tried several things, but am getting only a count of 1. Any help would be appreciated. select substr(a.table_name,1,15) , substr(b.t$desc,1,40) 2...

    nemsmith30 pointsBadges:
  • Stored procedure to transfer data in Oracle SQL Developer

    How can I write a stored procedure to transfer data from staging table to target table in Oracle SQL Developer? stagging table (stagcoindesk) to (coindesk) target table. Was thinking about this code: CREATE PROCEDURE YourProcedure AS TRUNCATE TABLE YourTable INSERT INTO YourTable SELECT * FROM...

    dreamersai5 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:
  • SQL query on tourism forecasting

    I have 11 years monthly data of tourist in India. Now I want a SQL query to find the next year forecast for tourist.

    vijaydev19665 pointsBadges:
  • 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:

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