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
- 14382 Views
- Cap Gemini, CGI, EDS, IBM, Satyam, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / deepak
Select * from employment table where salary between 1000 to
50000
| Is This Answer Correct ? | 25 Yes | 7 No |
Answer / yuvaevergreen
select * from employment where salary between 1000 and 5000
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / prasanna
select *from emp where salary between 1000 to 50000
| Is This Answer Correct ? | 9 Yes | 7 No |
Answer / dinesh
option 1:
Select * from empoyment table where salary >=1000 and <=50000
option 2:
select * from employment table where salary between 10000 and 50000
| Is This Answer Correct ? | 4 Yes | 3 No |
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 |
Answer / 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 |
Answer / dd
select salary from employment
where sal between 1000 and 5000
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / venu
Select * from employment table where salary between 1000 to
50000
| Is This Answer Correct ? | 4 Yes | 8 No |
how can i pull up a query which was previously stored in qmf
What keyword does an SQL SELECT statement use for a string search?
Explain about dbrm.
What is referential integrity?
Can one database have multiple instances?
What is the FREE command?
What is IMAGECOPY ?
What is a page?
What is the size of a data page?
Which catalog table stores referential constraints?
What is check constraint in db2?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
COBOL 
