Answer / vk

select studentid,student_name,marks from
(select row_number() over (partition by marks order by marks desc) as rnk,studentid,student_name,marks from student_marks)
where studentid in (1,4);

Answer / lokeshwaran s

SELECT MAX(marks) AS second_highest_mark
FROM student
WHERE marks < (SELECT MAX(marks) FROM student);

Answer / koti,khammam

select max(mark) from student where mark not in (select max
(mark) from student)

Answer / poomanibe

with temptab as
(
select row_number() over(order by substring(marks,1,2)) as
rownum,* from Student
)
select * from temptab where rownum=1

Answer / dharmendra k. dixit

SELECT TOP 1 Marks (SELECT TOP 2 Marks from Tablename Order
by Marks Desc)From Tablename order by Marks Asc

Answer / rupa

Select max(Marks) from Marks where Marks <
(select max(Marks)from Marks)

Answer / sagesh

SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY mark) AS Stu_Rank
FROM student) As T
WHERE Stu_Rank = 2

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

Do you know what are the reporting services components?

0 Answers  

How to create a new table in a given schema?

0 Answers  

Should you normalize audio?

0 Answers  

Can we write trigger for view?

0 Answers  

How to insert multiple rows with a subquery?

0 Answers  

What is the difference between having and where clause?

4 Answers  

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

What's the purpose of Stored Procedure?

6 Answers   Wipro,

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

What is optimistic concurrency?

0 Answers  

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,