Interested to Buy Any Domain ? << Click Here >> for more details...
i have an employment table whch has salary,dept,name? i want
salary b/w 1000 to 5000 can anyone pls say the query for ths ?
- 8 Answers
- 13806 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / deepak
Select * from employment table where salary between 1000 to
50000
| Is This Answer Correct ? | 25 Yes | 7 No |
Answer / yuvaevergreen
select * from employment where salary between 1000 and 5000
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / prasanna
select *from emp where salary between 1000 to 50000
| Is This Answer Correct ? | 9 Yes | 7 No |
Answer / dinesh
option 1:
Select * from empoyment table where salary >=1000 and <=50000
option 2:
select * from employment table where salary between 10000 and 50000
| Is This Answer Correct ? | 4 Yes | 3 No |
Hi All
See the ques properly, he wants rows with salary bwtween
1000 to 5000. If one say between, it wont means inculsion
of 1000 and 5000 thus query will be
select * from employee where salary bwtween 1001 and 4999
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / rabindra mishra
Select * from employment table where salary >= 1000 and
>= 50000
It will work Faster then all the above queries
| Is This Answer Correct ? | 5 Yes | 7 No |
Answer / dd
select salary from employment
where sal between 1000 and 5000
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / venu
Select * from employment table where salary between 1000 to
50000
| Is This Answer Correct ? | 4 Yes | 8 No |
What is meant by the attachment facility?
Why use RUNSTAT Utility?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Could anyone clearly explain the diference between sub query and correlated sub query?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is collection in db2 bind?
What is a synonym? How is it used?
What is db2 instance?
What is load replace in db2?
How to take backup of table in db2?
COBOL 
