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
- 14383 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the physical storage length of time data type?
How connect db2 database to datastage?
Are views updateable?
What is a db2 collection?
Explain in detail about buffer manager and its functionalities?
What is the use of db2?
What is release/acquire in bind?
How to retrieve rows from a db2 table in embedded sql?
What is bind in db2?
What is ibm db2 connect?
How do I start db2 in windows?
What type of database is db2?
Which components manage deadlocks in db2?
What is a db2 table?
