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
- 11808 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vaneesh khurana
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 |
Post New Answer View All Answers
What is plan in cobol db2?
What are the various isolation levels possible?
Before you give the explain statement, what are the prerogatives?
What is the role of the data page in the db2 database?
Which isolation level provides maximum concurrency?
What is blu acceleration in db2?
What is the use of dclgen in db2?
Is db2 a mainframe?
How do I import data from excel to db2?
What is schema in db2?
Explain the contention situations caused by locks?
Which command is used to remove all rows from a table?
What is the difference between plan and package in db2?
Define db2.
What is alias in db2?
