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
- 6718 Views
- I also Faced
- E-Mail Answers
Answer Posted / arbind panigrahi
select * from deptname where salary<=5000
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is a full text index?
How do you delete a data source?
Is foreign key a primary key?
How to invoke a trigger on demand?
How much memory that we are using in Logshipping Concept?
What is primary key, unique key, and foreign key?
Explain how to use linked server?
How to find related tables in sql server?
How is sql used in sql server?
What is exclusive locks?
What is the difference between varchar and varchar(max) datatypes?
Explain features and concepts of analysis services?
What is database replication? What are the different types of replication you can set up in sql server?
What is an etl file?
What happens when transaction log is full?
