Interested to Buy Any Domain ? << Click Here >> for more details...
Department
-----------
salary Deptname
1000 A
3000 A
2000 B
3000 B
4000 C
5000 C
select the deptname where salary >=5000
result should be:
Deptname
---------
C
please post only executed query in SQL server 2005
Asked By: Md. Niyaz
- 3 Answers
- 5653 Views
- I also Faced
- E-Mail Answers
Answer Posted / praveen s
C
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the significance of master, tempdb and model databases?
What are the types of normalization?
How to create an inline table-valued function?
What is service broker?
How to write a query with a full outer join in ms sql server?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is table-valued sub query?
What is the boxing and unboxing concept in .net?
How to insert data with null values?
What is etl - extraction, transformation, and loading?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is difference between group by and having?
What is a Join and explain its types?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Tell me what is fill factor?
