I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / siva prakasam
SELECT TOP (1) stuMark
FROM Student
WHERE stuMark < (SELECT MAX(stuMark) FROM Student)
ORDER BY stuMark DESC
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the difference between TRUNCATE and DROP?
What is the use of @@spid?
what is nonclustered index
What is join query?
Why Master database is required?
Write a SQL query to make a column as unique?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What are the different editions available in sql server 2000?
how many type of indexing in database?
Explain collation?
What are the properties and different types of sub-queries?
How to populate a table in sql server?
What are xml indexes?
What is the dbcc command and why is it used?
What do you know about normalization and de- normalization?