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
- 12362 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
Which command is used to remove all rows from a table?
can all users have the privilage to use the sql statement select * (dml)?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Explain in brief how does db2 determine what lock-size to use?
Which isolation level provides highest data integrity?
What is the difference between using bind () and rebind () methods of naming class?
What are union and union all?
what is diffrence b/w file-aid tool and file-aid utility???
What action db2 takes when a program aborts in the middle of a transaction?
How can the duplicate values be eliminated from db2 select?
What is an instance database?
How does cobol compile db2 program?
List out the three types of page locks that can be held.
Can we update view in db2?
What is explain in db2?
