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
- 5990 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
How to execute a sql statement using mssql_query()?
Is truncate autocommit?
How do I find the sql server version?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What are different types of raid levels?
What are the ways available in sql server to execute sql statements?
Explain about builtinadministrator?
Explain “row_number()” in sql server with an example?
What are the advantages dts has over bcp?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
How many database files are there in sql server 2000?what are they?
Explain trigger classes i.e. Instead of and after trigger?
Can you explain powershell included in sql server 2008?
Define clusters?
