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
- 11813 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answer Posted / deepak
Select * from employment table where salary between 1000 to
50000
| Is This Answer Correct ? | 25 Yes | 7 No |
Post New Answer View All Answers
How is deadlock resolved?
List down the data types in the db2 database.
What is the difference between drop table and delete table?
Are view updateable?
What is temporal table in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How will you return the number of records in table?
What is view db2?
What are the various data types available in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is explain in db2?
Define db2 and its databases?
What is the clustering index in the db2 database?
What is coalesce in db2?
What are the 2 sqlcodes that are returned?
