Interested to Buy Any Domain ? << Click Here >> for more details...
Department
-----------
salary Deptname
1000 A
3000 A
2000 B
3000 B
4000 C
5000 C
select the deptname where salary >=5000
result should be:
Deptname
---------
C
please post only executed query in SQL server 2005
Asked By: Md. Niyaz
- 3 Answers
- 5665 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajkumar
Select Deptname from Department Where salary >=5000
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why are sql functions used?
Explain difference between control flow and data flow?
What is repeatable read?
What is the difference between truncate and delete commands?
Can two tables have the same primary key?
Can two different columns be merged into single column? Show practically?
Mention the uses of stored procedures.
How to generate create view script on an existing view?
What is a covered index?
What is oltp (online transaction processing)?
How many triggers are possible per table?
Explain the functionalities that views support?
what is an extended stored procedure? : Sql server database administration
What is difference between inner join and join?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
