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
- 14384 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 commit in db2?
List out the data types available.
How do I add a column in db2?
What is a db2 tablespace?
Describe major components of db2?
what is the sqlcode -501
What is the advantage in De-normalizing tables in DB2?
How do you find the maximum value in a column in db2?
What is copy pending and check pending in db2?
What is nvl in db2?
What is the role of schema in the db2 database?
What is package in db2 mainframe?
How does a cursor work?
What is view db2?
What is null value in db2?
