i need to know how i display department which has salary >
=5000 for the below table
Department
-----------
salary deptname
1000 a
3000 a
2000 b
3000 b
4000 c
5000 c
kindly send the query to thilakvinoth13@gmail.com
Answer Posted / guest
select deptname from department where salary>=5000
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What are the new features are introduced in sql server 2012 reporting services?
How to find Duplicate Records In table?
Are semicolons required at the end of sql statements in sql server 2005?
How many instances per computer are there in sql server 2000?
What is surrogate key? : sql server analysis services, ssas
What is deploy, process and build? : sql server analysis services, ssas
How to move database physical files in ms sql server?
What is a group function explain with an example?
Why do we partition data?
How to convert numeric expression data types by assignment operations?
Explain syntax for disabling triggers?
What is the difference between a local and a global temporary table?
What is spatial and temporal data?
What is change data capture (cdc) in sql server 2008?