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
Answers were Sorted based on User's Feedback
Answer / maulesh
Select Deptname
From Department
Where salary >=5000
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rajkumar
Select Deptname from Department Where salary >=5000
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query
how to determine the service pack currently installed on sql server? : Sql server database administration
What are the various editions of sql server 2017 that are available in the market?
write coding for importing sql data into a word excel...
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Can we insert data into view sql server?
what is meant by deafult in sql server?
Can multiple columns be used in sql group by clause in ms sql server?
What is the new security features added in sql server 2014? : sql server security
How will u find the query which is running in some other machine
4 Answers CarrizalSoft Technologies, IBM,
How do I find information about the install locations for the various instances running on a computer?
how to avoid cursors? : Sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)