Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
No Answer is Posted For this Question
Be the First to Post Answer
How do I find sql server instance name?
What is partition, how will you implement it? : sql server analysis services, ssas
What are the different normalization forms?
Define union, union all, minus, intersect?
What is meant by indexing files?
Can sql servers link to other servers like oracle?
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
Delete duplicate records from the table?(Table must have unique id)
7 Answers TCS, Thomson Reuters,
What is row by row processing ?
What objects does the fn_my_permissions function reports on? : sql server security
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)