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
- 14179 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 language is db2 written in?
How can you do the explain of a dynamic sql statement?
What is the picture clause of null indicator variable?
What is null indicator in db2?
What is the usage of open cursor command?
What is ibm db2 used for?
List out the three types of page locks that can be held.
What are the various data types available in db2?
What is a db2 package?
Mention the definition of cobol in varchar field.
What's The Error Code For Unique Index Voilation?
What are host variables in db2?
Explain what are the various isolation levels possible?
How to find schema of a table in db2?
How do I add a column to an existing table in db2?
