• SQL query: Find out the count of employee whose name is more than one time

    In SQL, how do I find out the count of employee whose name is more than one time in a table?

    meghanap5 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 pointsBadges:
  • Create a sequence called Store_seq with the following values: increment by 10, start with 500

    Create a sequence called Store_seq with the following values: increment by 10, start with 500

    VB RD45 pointsBadges:
  • SQL query for employees in my department

    We need to find 50% of employee from each department, who is getting max salary. And every department have different employee count. ex. finance may have 100 employees and sale may have 40 employee. How do I write a query for this?

    mukeshkumar1230 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:
  • Learn to use SQL queries

    I'm a beginner in computer science so how can I make grip on Oracle SQL Plus. Is there any website or any electronic book that contains preset queries on SQL which can help me in working in SQL. I want a guide book which has queries to start and work in SQL Plus and developer.

    Yasir oracle5 pointsBadges:
  • show zero sum in sql query

    i want to display for all regions sum value. The region 4 is 0 but it is not displaying 0

    Rola77720 pointsBadges:
  • How to kill session in Oracle application express

    I created a report through SQL query "select sid,serial# from v$session" with check boxes beside them. I want to kill session using sid,serial# of checked row by creating process in PL/SQL.

    hemanthroy3695 pointsBadges:
  • Issues deleting records in SQL database

    I'm having issues deleting records in a SQL database. What should I do?

    rockquery45 pointsBadges:
  • Slow performance for a SQL query

    I have a SQL query I am running, but it is experiencing significant slowdown. The main table - has over 1 million records and a unique key of cusID. It has a one to many relationship with the other two tables mentioned. The query code is as follows: Select customer.cusID,customer.VisitDate,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using .NET gridview control with AS/400

    I am tiring to update a table in the AS/400 with the .NET gridview control and I am having trouble binding the parameters to the SQL query. My select query work if I use a liked server but it is slow. Next I tried the ODBC driver but my select query is not working with the same input parameters....

    DJJIII5 pointsBadges:
  • Using SQL code to read a filename

    Can you write a SQL query that will read PDF filename from a dir and then match the filename to a data element in a table having the same name? For instance, the filename is 12345.pdf where 12345 is actually an invoice number. Can the query read the filename and then locate the same invoice number...

    Teedee5 pointsBadges:
  • Using SQL to insert records into a table

    I have a table with a period in the table name, i.e. AB.CDE that I need to insert some records into. When I query the table (Select * from "AB.CDE") it works fine. When I try to insert records (insert into "AB.CDE"), however, I get a file not found message. Does anybody know why this is happening?

    GaryF60 pointsBadges:
  • row_number in SQL 2000

    How do I find out the row_number in SQL 2000 like using row_number() function in SQL 2005?

    Rl10 pointsBadges:
  • How to check JDBC agent connected with RTCP?

    Currently I'm working with JDBC virtualization IBM RIT. I created testcase for database with a basic SQL query and it is working fine. Now I'm facing issues while creating stub with database. It's showing DJBC agent not connected with RTCP. I got struck up with that step. Don't know how to proceed...

    Mathumathi5 pointsBadges:
  • Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Sameera5 pointsBadges:
  • Equivalent for crosstab query

    Is there any function in MySQL that can create a query similar to crosstab query in MS Access?

    Sgheorghian5 pointsBadges:
  • Free SQL software with interface to enter data

    Hi, I need to enter about 5000 lines of data with about 10 columns. and then I would query the data (by lets say SQL, but I'm open to suggestions). Can anyone recommend a simple freeware to use. My queries would be like ordering the data based on certain column, or getting to view only that data...

    Maqib1005 pointsBadges:
  • How to create date in SQL Server 2000

    I created a table with attribute date and i want to store date as "Date-Month-year". What procedure to create a date and how we able to insert the required format by using SQL Server 2000?

    Malikjavediqbal30 pointsBadges:
  • Building an xml in java

    Please give me an example of building an xml with multiple child nodes, in java. I want something like : <Parent> <Child1>something</Child1> <Child2>something else</Child2> </Parent> Now, the values for Child1 and Child2 must be picked using SQL from AS400....

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

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.