1
  • Need help with Oracle query

    How to display the third highest salary from an employees table in Oracle. Thanks in advance.

    Xaviervicky30 pointsBadges:
  • Challenge improving query performance on large tables

    Hi, Here's the structure of the db I'm using: * Table frs_ArticlesBDFournisseur which contains article main data.One row per article/color. Key is Refrefart (int). Size is over 220000 rows at the momemt. Only index is the PK (clusterred). * Table frs_ArticlesBDFournisseurTaille contains all the...

    Sport200025 pointsBadges:
  • Infinite recursion in SQL Server 2000

    consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?

    Gomsbk35 pointsBadges:
  • AS400

    I am having problem with LF not reading correctly.  Can you turn off QUERY Optimizer for one job or a program?  If so how do you turn off Query Optimizer?

    CHARLESG25 pointsBadges:
  • Calculating prior Query fields

    Inside my query, is four listed fields; date, printer, and a Start and End meter for daily meter readings to keep track of printer impressions. I'm trying to receive a return value by subtracting a meter reading from the START field in a current row and the END meter in the previous row depending...

    Bostic8720 pointsBadges:
  • View is taking so much time for fetching data

    i have created multilevel view (ie:- a view is inheritng data from multipe view) and its taking so much time while fetching the data. can i reduce time taking for fetching data.

    44063860 pointsBadges:
  • Updating a field and counting unique field values from another fields all in the same query?

    How can I structure the following query to allow me to count the number of unique entries in a field named "amount" and using the same query, update another field named "unique" Here is what I am doing: SQL = "select amount, count(amount) from tblmessagein group by amount having count(*) = 1" If...

    Grantp40 pointsBadges:
  • Need help with this Oracle Query

    BPC_APPLICATIONS_TRANSACTIONS (Table) Application_no,Transaction_no,Transaction_date Step_id Dept_code Decision 20090045 1 01/14/2009 10:07:17 1 001 0 20090045 2 01/14/2009 10:07:17 70 007 0 20090045 3 01/14/2009 10:08:57 1 001 0 20090045 4 01/14/2009 10:08:57 60 006 0 20090045 5 01/14/2009...

    FidanSheza10 pointsBadges:
  • Matching External lists to your Database?

    Hello everyone, I work in a telco and manage the data in the company's CRM. I'm often given lists of company names by our alliance team, and asked to match the list against our database to see which companies already exist in the CRM and which don't. At the moment I can only accomplish this by...

    Nik145 pointsBadges:
  • To retrieve records from SQL Server database

    Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named "Name" in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on.... Now, through...

    Pichha5 pointsBadges:
  • Query performance and tuning

    Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when it does sorting it hangs.But I need to do the...

    Mingley5 pointsBadges:
  • Clustered and Non-clustered Index

    Hi, I have one table having more than 3 millions rows with following columns: [SITE_ID] [USER_NAME]

    Plugsharma40 pointsBadges:
  • Optimizing Query

    Hi, I am having a table which is having around 170 Columns(Don't blame me but my Developer) and there are only 989 records in the table.I created all sorts of Indexes but still the query (Select * from Table) takes almost 2 mins to display 989 records.I need all the columns to be displayed.Is there...

    Sachin VCO15 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