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
- 8246 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
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is sql or structured query language?
How can I check that whether automatic statistic update is enabled or not?
List out the different types of locks available in sql server?
Why should you use or avoid select * statements?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How efficient you are in oracle and SQL server?
what is the difference between openrowset and openquery?
Can you index views?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Why and when do stored procedure recompile?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is the primary use of the model database?
How to connect php with different port numbers?
What are different types of constraints?
