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
- 68609 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rupa
Select max(Marks) from Marks where Marks <
(select max(Marks)from Marks)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are secondary xml indexes?
What is data compression? : sql server database administration
What are the differences between DDL, DML and DCL in SQL?
Why do we need different type of parameter?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is filter index?
Do you know what are acid properties of transaction?
What is difference between cte and view?
What is the difference between executequery () and executeupdate ()?
What is sql server query analyzer?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What is named query? : sql server analysis services, ssas
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Explain the flow of creating a cube? : sql server analysis services, ssas
what's new in sql server 2016?
