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
- 7783 Views
- I also Faced
- E-Mail Answers
Answer Posted / arbind panigrahi
select * from deptname where salary<=5000
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the difference between a primary key and a unique key? Are they the same?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How to get a list of all tables with "sys.tables" view in ms sql server?
What functions can a view be used to performed?
What is the standby server?
How to configure and test odbc dsn settings?
How to set database to be read_only in ms sql server?
Which table keeps information about stored procedures?
What is difference between delete & truncate commands?
What do you mean by a Composite primary key?
How to get nth highest salary from employee table.
What are the triggers in sql?
What does the not null constraint do?
what is the difference between Tabular and Matrix report?
What is the function of inner join?
