Answer Posted / indraneelandhavarapu
SELECT MIN(SALARY) from EMPSAL
OR
SELECT MAX(SALARY) FROM
(SELECT DISTINCT TOP 1 SALARY
FROM EMPSAL ORDER BY SALARY) AS A;
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Explain what is lock escalation?
Does server sql treat char as a variable-length or fixed-length column?
What is the use of nvl work?
Explain timestamp datatype?
What is the correct order of the logical query processing phases?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Explain atomicity?
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.
What is dml command?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Do you know what is sql injection?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What are the limitations in ssrs on sql server express edition?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is indexed view? How to create it?