Hi there experts.

I know basic queries but Im having a confusion on this matter.

Ive been mostly using WHERE clause in a select statement but Im not quite sure when to use HAVING.

When should I use this clause and not WHERE clause?

I would be very happy if youll help me out on this.

Hi

Iam new to DB2, how do i find total number of rows in DB2 table, select a row using indexes in DB2?

Thanks

Hi there!

I need somebody to please tell me how to get the current date?

I will compare my record to the current record?

What is the query for it?

Thanks.

Hello there techyv experts!

I need someone to help me on this matter.

In my database, Each employees have their salaries computed.

What is the query to display the top 5 employees having the lowest salary?

Thank you so much.

Good day!

I have read on this but I need some DB experts to confirm this one.

Is it really possible to display an MS Excel Spreadsheet by using or through an ASP page..?

How can I view it if its possible..? 

Hello everyone.

I just want some help on this. I want to insert a column "N" in my database with a data type TIME.

I already did some research, but it still wont work. The error says it overflows.

Does anyone care to give me the right syntax and example in inserting this type of column n n..? 

I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?

Hi,

I want to know what are the duties of a Database Administrator (DBA) when in terms of getting access privilege. Can you please cite some categories that you can see in Database Management System (DBMS) evaluation and selection list?

Hi,

While installing Sametime v8.5.1, the installation of DB2 has failed. An error message occurs that displays the following text

Installation Manager fetched 1 files (437.61 MB) during this installation attempt. You can keep these files to avoid fetching them again. Installation manager will delete these files during a successful installation of this or any other package.

What should I do now?

Thanks in advance.

DB2 can return SUM function apart within a declaration. If I have the following situation: POWER SELECT SUM (AMOUNT), COUNT (*) FROM table WHERE POWER IN (180002.180092) gives Rama the amount and the Count 180,002, +100.3 which I can return into two values, one is the positive values of the number and one for negative numbers yield: Branch, credit, debit, account 180002, -100, +200.3. How can I accomplish this? Any ideas? Thanks.