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
- 11771 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 |
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
can any one give the list of some important sql abend codes which r frequently asked in interviews?
how 2 resolve the -311 sqlcode
Define data page.
What are db2 objects?
Why cursor is used in db2?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is null indicator in db2?
How do I delete a column in db2?
if i made sme changes in sub pgm wht r the things to be done for this ?
How can you do the explain of a dynamic sql statement?
Name some fields from SQLCA
COBOL 
