SELECT * FROM department WHERE salary>=5000

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

Question Posted / chandra10shekhar

6 Answers
7795 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

Please Help Members By Posting Answers For Below Questions

What is normalization and denormalization in sql server?

994

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1066

What are rest-style architecture's?

170

What do you understand by mirroring?

986

What is extent? Types of extents?

1160

Is foreign key a primary key?

1053

Can You Use Data Mining Models In Ssrs?

145

Can we use having clause without group by?

960

what are the disadvantages of cursors? : Sql server database administration

1016

How to convert numeric values to integers in ms sql server?

1062

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.

2498

What are the advantages of policy management?

982

Explain what is dbcc?

995

Explain the microsoft sql server delete command? : SQL Server Architecture

1052

What do you understand by mirroring and mention the advantages of the mirroring?

1046