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
- 6041 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
What type of Index will get created after executing the above statement?
State a few properties of relational databases?
How sql server executes a statement with nested subqueries?
What is tablesample?
What stored procedure would you use to view lock information?
What is the concept of optimization?
How can I check that whether automatic statistic update is enabled or not?
Which tools are available to manage SQL Azure databases and servers?
How to rebuild the master database?
How to drop an existing stored procedure in ms sql server?
What do you understand by the denormalisation?
Explain the rules for designing files and file groups in sql server?
What is report subscription?
Explain the steps needed to create a scheduled job?
Explain few of the new features of sql server 2008 management studio
