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 / chandra10shekhar
SELECT * FROM department WHERE salary>=5000
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is normalization and denormalization in sql server?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What are rest-style architecture's?
What do you understand by mirroring?
What is extent? Types of extents?
Is foreign key a primary key?
Can You Use Data Mining Models In Ssrs?
Can we use having clause without group by?
what are the disadvantages of cursors? : Sql server database administration
How to convert numeric values to integers in ms sql server?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are the advantages of policy management?
Explain what is dbcc?
Explain the microsoft sql server delete command? : SQL Server Architecture
What do you understand by mirroring and mention the advantages of the mirroring?