1
  • 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:
  • Order by clause in SQL Server subqueries

    why the "order by" clause in sub queries must be associated with "top" clause in sql server..??

    Karthikharve5 pointsBadges:
  • SQL 2008 query: return results where row not in another table

    hi, running sql2008.  i have the following two temp tables.  the first is just all web service errors for a date range.  the second is simply 20 rows that contain values of types of web service errors. --temp tbl #1 select [date],[err],[srv],[e1],[e2] into #tblExcept from netlog where [err] like...

    RdS1995 pointsBadges:
  • Update a subquery with different tables

    I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT ='01' where MVXJDTA.MITMAS.MMITNO =...

    Bartbart50 pointsBadges:
  • Subquery in Microsoft Access

    [em]   Trying to create a subquery for a table in Access.   I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the  table, and don't want to create another table with that...

    Miltonfung5 pointsBadges:
  • Subquery only returns column names

    I have the query below, but when I run it, I can only get column names to return. Can someone please help me??? For each subject there are multiple values at each marker. I want an average, by date, for each subject at each marker. I have spent literally hours on this... Thanks in advance for any...

    Docmom12315 pointsBadges:
  • SQL Plus

    I have a subquery that works but I need to change some parameters. Specifically 2 fields in a different table. When I do, using aliases, it stops working, "Invalid Identifier". The first select gets all the fields from 2 tables then the subquery uses the 2nd table. Table B has some fields as well...

    Gator255 pointsBadges:
  • Sql subquery

    how can we use sql subquery in jsp?i am trying to write it but it gives me an error of missing operand?

    Shruti5 pointsBadges:
  • Subquery?

    I used to think I was good with sql as I have used it for quite a few years with informix, but now I am trying to create an sqlplus with oracle and some things are not working the same. I have 3 tables. customer general customer detail location I have used a join to list all the required customer...

    MizzGail85 pointsBadges:
  • SUB-QUERIES

    Hi, Good you give me an best real example for using the sub query, correlation of sub query & Top analysis using subqueries. Thanks in Advance.................

    134915 pointsBadges:
1

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