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
- 67354 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
Explain what is “asynchronous” communication in sql server service broker?
How to write character string constants or literals in ms sql server?
What is BCNF? How is it better than 2NF & 3NF?
Do you know what is sql service broker?
When is update_statistics command used?
What is a system database and what is a user database?
What is conditional split?
Explain how you can configure a running aggregate in SSRS?
what is create database syntax? : Sql server database administration
what kind of lan types do you know? : Sql server database administration
Difference between 2NF &3NF ?
How to create a large table with random data for index testing in ms sql server?
How to add more data to the testing table in ms sql server?
Explain concepts of analysis services?
What is a hint?
