select deptname 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 / guest

6 Answers
7895 Views
I also Faced
E-Mail Answers

Answer Posted / guest

select deptname from department where salary>=5000

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is primary key index?

981

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

912

Which language rdl files made of?

130

How does stuff differ from the replace function?

1018

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1270

What are temporal tables in sql server 2016?

888

What are page splits? : SQL Server Architecture

992

Define magic tables in sql server?

1070

What is trigger explain with program?

986

Describe and explain about SQL native client?

1112

What can be used instead of trigger?

1156

What is table level trigger?

1026

What is transaction server isolation?

1042

What is database white box testing?

1125

Can we use pragma autonomous_transaction in trigger?

962