Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 68779 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohammed mujahid
select MAX (EmployeeSalary) from EmployeeDetails where
EmployeeSalary in (select MAX(EmployeeSalary) from
EmployeeDetails)
Here I have changed the table name and column name plz
check it ones with student details
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is default constraint?
What is the difference between Stored Procedures and triggers?
Explain syntax for viewing, dropping and disabling triggers?
Define synonym?
What is an indice?
What is the difference between clustered and a non-clustered index?
Explain what is it unwise to create wide clustered index keys?
How many types of schemas are there?
What program is used to store the data source file?
Explain having clause?
What is an example of a foreign key?
What are the benefits and tasks of object explorer? : sql server management studio
What is user-defined inline table-valued function?
How to reaname table name without using sp_Rename in sql server..?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
