database column where condtion

[#1]

Hi,

I need to fetch the column from db where the values lies between 100 to 1000.

the coumn name is Salary and my codition is to fetch the Salary from db where count of salary between 100 and 1000.

how to writhe above while condition while fetching from db with in the script not in the expression part.

provide me the solution

[ashfaq_haseeb]

Hi try below

Load

EMPID,

Ename,

Salary;

sql select *  from table

Where Salary >100 and Salary <1000;

Regards

ASHFAQ

[jjordaan]

Hi,

You can use a query like;

SELECT

     Field1

     ,Field2

     ,COUNT(Salary)

FROM table

WHERE Field3 = ?? (if you need to filter)

GROUP BY Field1, Field2

HAVING COUNT(Salary) >= 100 AND COUNT(Salary) <= 1000.

Hope this helps

[senpradip007]

Try like:

Select * from [Your Table] where salary between 100 and 1000;

[vardhancse]

we can write the where condition after table name.

[#6]

Hi Guys ,

its not working can you check from your end

[jjordaan]

Do you receive an error?

Can you be a bit more specific

[joshabbott · Accepted solution]

We probably need a bit more information before we can answer.  Is your datasource a spreadsheet?  Access DB?  SQL Server DB?  No matter what it is, you should be able to get it using a preceding load, add the bolded below:

[Table Name You Define]:

LOAD *;

  ALL OF YOUR LOAD SCRIPT HERE

Where [Plug Your DB Field Name Here] >= 100 and [Plug Your DB Field Name Here] <= 1000;

[#9]

Josh Abbott,

Thanks for your solution.

Your approach is correct.

Thank you

[#10]

Hi please close the question and make it as correct answer