Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 8126 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandra10shekhar
SELECT * FROM department WHERE salary>=5000
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of sql profiler in sql server? : sql server database administration
Ways to improve the performance of a SQL Azure Database?
What are 3 ways to get a count of the number of records in a table?
Explain the flow of creating a cube? : sql server analysis services, ssas
How to round a numeric value to a specific precision?
what are the different types of replication you can set up in sql server? : Sql server database administration
How do you create a clustered index?
How to list all field names in the result set using mssql_field_name()?
What is the function of inner join?
How to select some specific rows from a table in ms sql server?
Explain where clause?
Describe how to use the linked server?
How to write a query with a left outer join in ms sql server?
Define ACID properties in a Database?
What does it mean to normalize a database and why would you do it?
