Answer Posted / amruta dash
select max(salary) from tblname where salary not in (select
max(salary) from tblname);
Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
Explain the third normal form(3nf)?
What is user-defined function?
What is the temp table?
What is the usage of sign function?
How can I track the changes or identify the latest insert-update-delete from a table?
What happens if ntwdblib.dll is missing on your machine?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is sql service broker?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
How to execute stored procedure and set temp table in sql server?
Where views are stored in sql server?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Differentiate between sql temp table vs table variable?
Can you explain what is the use of custom fields in report?
How to concatenate two strings in SQL Server.