• 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:
  • 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:
  • 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:
  • Connectionstring for paradox db password protected

    Hello everybody, Searching for answers I've found this interesting page!! I've created a SQL query to a paradox database, it works fine with a non- password protected table: Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended...

    Starbasestarfleet20 pointsBadges:
  • Automate TSQL Query Output

    I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?

    Eabouzeid175 pointsBadges:
  • SQL query

    I have a table like this... emplid   qualification 101           b.tech 101            java 101            cpp 102            java 102            sql I want the output as: emplid      qualification1       qualification2          qualification3 101      ...

    raghib5 pointsBadges:
  • Writing a SQL query for an Oracle table

    We have this data in an Oracle table (here it is below): MONTH VALUE 1 100 2 200 3 300 4 400 5 500 6 600 So we need to write a SQL query so the results are showing like this: MONTH_JAN MONTH_FEB MONTH_MAR MONTH_APR MONTH_MAY MONTH_JUN 100 200 300 400 500 600 Any help would be appreciated.

    ITKE350,945 pointsBadges:
  • Comma Separated values using XML PATH in SQL Query

    Hi This is my first time to post my complex query here I am facing the critical problem for comma separated values in the column using XML PATH Let me explain you in brief now I have a table CallDetailReport table with below mentioned structure which stores values like CallStartDateTime[DateTime]...

    cnu12525 pointsBadges:
  • Receiving ORA-00918 error when running SQL query

    In Oracle, I keep getting this ORA-00918 error: Column ambiguously defined when I'm running this SQL query: SELECT * FROM (SELECT DISTINCT(coaches.id), people.*, users.*, coaches.* FROM "COACHES" INNER JOIN people ON people.id = coaches.person_id INNER JOIN users ON coaches.person_id =...

    ITKE350,945 pointsBadges:
  • Oracle SQL Query

    I have created two tables. One is Item_Master table with the fields Itemno having Primary key and must begin with letter ‘I’, Item_Name(HDD, MONITOR, CDROM, KEYBOARD, UPS), Stock defined as Not Null and Price which is greater than 10000 and less than 30000.Another table is Item_Trans with the...

    RaviMangalore5 pointsBadges:
  • Compare two file data row by row in SQL

    I need to compare two files (Previous data and current data) with same fields but changed in some fields value in Current sheet. I want to compare both files and filter only those records which are changed.  Ex. Previous Data: Reference name Address contact 123A Jhon USA 123 123B Paul UK 457 123C...

    sgautam11110 pointsBadges:
  • I want to parse data from one field into two based upon criteria.

    I have lots of data with disparate information in one field and I need to take all information to the right of any * that might appear into a separate field? There will be an * about 10% of the time. Examples of the field in question. Example 1: CKD Stage I ****250.40/585.1 Example 2: /Prosthesis...

    JohnSouthFlorida5 pointsBadges:
  • How to I write a SQL query to ignore case in a Oracle database?

    In my Oracle database, I have a SQL query that I want to ignore case. See below: SELECT * FROM TABLE WHERE TABLE.NAME Like 'IgNoReCaSe' So if I want the query to return either "IGNORECASE", "ignorecase" or a combination of them, how can I do that? Would that be possible?

    ITKE350,945 pointsBadges:
  • Can I do a MySQL dump by a SQL query?

    Can I do a "mysqldump" by a single SQL query? What I basically mean is that I want to dump the whole database. Thanks so much!

    ITKE350,945 pointsBadges:
  • Help with SQL query

    Dear friends, I am working on squirrel and wrote a query which is like this: select sum((coalesce((Sent_128),0)))*(365/(count(distinct(date_created))))/(((sum(coalesce((quantity2),0))/(count(distinct(date_created))))+(sum(coalesce((qu antity),0))/(count(distinct(date_created)))))/2) as "final" from...

    animeshdubeyad5 pointsBadges:
  • What’s the best SQL Query Formatter tool?

    Hi experts, Is there any free SQL query formatter tool? I am using this free SQL Query Formatter Tool for small queries. It is very good tool. But I can not customize everything what I would like, like fonts and colours. Is there any other good free tool?

    sulica255 pointsBadges:
  • Multi-member file in AS/400 (SQL query)

    On my AS/400 in an interactive SQL (5250 session),select * from myfileonly returns rows from one member when "myfile" has more than one member. But how can I get rows from a specific member? Thanks for the help!

    ITKE350,945 pointsBadges:
  • RUNSQLSTM

    Hi All, My below SQL query is running fine: - SELECT a.USRP,a.USER1, SUBSTR(a.USER1,23,3) as Template, BRCB, b.MGRP,b.ICDE,INAR,a.SECL,ACA1,ACA2,ACA3,ACA4,ACA5,ACA6 FROM muserdd as a left outer join MACBRDD as b on a.USRP = b.USRP left outer join MITEMDD as c on b.MGRP = c.MGRP and b.ICDE = c.ICDE...

    6r1,590 pointsBadges:
  • DB2 reorgchk current statistics on table all

    With help of below query we are getting output for all tables and indexes  "db2 reorgchk current statistics on table all". But I want only those tables which we can reorg on that tables like *---*,--** etc..... Please provide me SQL query where I can see only that tables name where they require...

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

Following