...456789
  • sql quries

    i m a beginer in computer science.so how can i make grip on oracle sql plus is there any website or any electronic book that contains preset quries on sql which can help me in working in sql i want a guide book which has quries to start and work in sql plus and developer.

    Yasir oracle5 pointsBadges:
  • Using co-related queries in SQL

    How do you use co-related queries in SQL and why would they be useful? Is there any effect on performance when executing a co-related query?

    SQL Server Ask the Experts2,585 pointsBadges:
  • iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd

    Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...

    MarcGreen20 pointsBadges:
  • Return zero when there’s no data

    I am trying to write a query that I can use to generate an Excel chart to show activity in our database. I have it returning rows for each minute over the previous two hours (no problem). The problem comes when I plot a line chart. If there's no activity in a given minute, there's no row returned,...

    DanM5 pointsBadges:
  • sql query

    from this table i have to take those records that have common gridcode and then from these records i have to store the records having maximum area in another table... gridcode state area 13013 rajasthan 50000 13013 gujarat 45000 13014 rajasthan 25000 13014 gujarat 25000

    Aanshi1235 pointsBadges:
  • SQL Query for time data only

    I need to query a large remote weather database for events reported within time frames without regard for the day. For instance, I need all data that was reported for the fifteen minute window closest to noon each day for the last twelve years. I don't care about specific dates, just the daily time...

    C Pete15 pointsBadges:
  • MySql Query

    Hi Gurus i have a problem in MYSql Query Browwser there is a table "jiuser" in "jasperserver" database. this table has a column "username". there is another table " jiresourcefolder" in the "jasperserver" database. this table has a column "uri". now i wana find out which user can access which uri....

    Abhi Here20 pointsBadges:
  • Having problems converting SQL Server queries to stored procedures

    I am using SQL Server queries as in-script and I have now decided to use the queries as stored procedures. However, I am facing some problems while converting the SQL Server queries into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to make a single row in SQL

    Dear all, Please help me I am not good in sql queries. I have a view like this. SNo Employee title Cdate IN TIME OUT TIME 258 john accountant 27/01/2008 7:28:12 258 john accountant 27/01/2008 7:28:30 258 john accountant 27/01/2008 16:03:42 258 john accountant 27/01/2008 16:03:48 258 john accountant...

    Binu.emiliya10 pointsBadges:
...456789

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