I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answers were Sorted based on User's Feedback
Answer / b.bathakaraithangam,giri
select * from student where mark=(select max(mark) from
student where mark not in (select max(mark) from student))
Is This Answer Correct ? | 2 Yes | 0 No |
select distinct mark from student_mark s
where (select count(distinct s1.mark) from student_mark s1
where s1.mark>=s.mark )=4;
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / shrikant
I have student marks in a student table. I need all record
where second highest mark .Then what will the query for this?
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rias
Select MIN(MARK) from student where mark in (select Top 2
mark from student order by mark desc)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sadaq moulani
select top 1 marks from student where marks in(select
distinct top 2 marks from student order by marks desc)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / rajat kumar
select top 1 marks from student where marks <(select max(marks) from student) order by marks desc
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kunal sain
select mark from student s
where 1=(select count(*) from student s1
where s1.mark<s.mark);
Is This Answer Correct ? | 5 Yes | 5 No |
Answer / sanah
select top 1 marks from marks where marks
<(select max(marks) from marks) order by 1 desc
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / abhishek srivastava
select top 1 marks from (select top 2 distinct marks from
students order by marks desc)
order by marks
Is This Answer Correct ? | 3 Yes | 3 No |
How will you go about resolving deadlocks?
What are scheduled tasks in sql server?
What are the restrictions while creating batches in sql server?
i need some interview questions on sql server developer plz any onee send some links.
Describe the left outer join & right outer join. : sql server database administration
System variable and temporary variables
How to store pdf file in sql server?
1 Answers CarrizalSoft Technologies, College School Exams Tests, TATA,
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
Can you explain what is indexed view? How to create it?
What are the types of sql server?
How the authentication mode can be changed?
Is it ok to shrink transaction log?