Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20430 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / anjum
SELECT MAX(SALARY)FROM EMP WHERE SALARY(SELECT MAX(SALARY)
FROM EMP)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain what is cte (common table expression)?
Name three of the features managed by the surface area configuration tool? : sql server security
Will the writetext statement activate a trigger?
What will be the maximum number of index per table?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
If a table does not have a unique index, can a cursor be opened on it?
Can you pass expressions to stored procedure parameters?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What are the differences between left join and inner join in sql server?
What is data source in connection string?
How to list all field names in the result set using mssql_field_name()?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Explain contrast amongst grouped and non-bunched records?
What do you mean by the term 'normalization'?
Differentiate sql server reporting services vs. Crystal reports?
