Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7915 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 drop an existing user defined function in ms sql server?
Can you explain what is indexed view? How to create it?
How does stuff differ from the replace function?
How do you debug a procedure in sql server?
Can sql servers linked to other servers?
What is the difference between primary key and unique constraints?
Explain indexed views and partitioned view with their syntax.
How many types of triggers are there?
Explain active/passive and active/active cluster configurations?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How to scale out a federation by Sql statement?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
How to optimize stored procedure optimization?
What is subreport?
How optimize sql query with multiple joins in sql server?
