one table has four field id,name,design,salary. i have to
find maximum salary .
Answer Posted / prashant
Select * from table1 where salary = (select max(salary)
from table1)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Can you explain about buffer cash and log cache in sql server?
What is difference between clustered index and non clustered index?
Define compound operators?
What are the commands used in DCL?
What is the template in sql?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What area unit the various kinds of info compression introduced in sql server 2008?
Explain about temporary stored procedure?
How to change the ownership of a schema in ms sql server?
How many types of cursor type are there?
Explain primary key?
Define Joins?
how many no of arguments can be passed in procedures and functions
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is normalization and what are the advantages of it?