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
- 69881 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / aaaa
SELECT * FROM `student` WHERE class='Six' ORDER BY mark DESC
LIMIT 1,1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Explain the steps needed to create a scheduled job?
How to disable triggers using "disable trigger"?
How many types of subqueries are there in sql server?
What happens when the SQL Azure database reaches Max Size?
Can one drop a column from a table?
How to start and end transact-sql statements?
Explain filtered indexes?
What command do we use to rename a db, a table and a column?
How global temporary tables are represented and its scope?
Is foreign key a primary key?
Write a SQL query to delete a table?
What is a partition function in sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is the use of RDBMS?
