How to select nth record from a table?
Answer Posted / karthik
select * from (select rownum r , emp.* from emp)
where
r='&n'
Give the value of n. It will return the nth record.
| Is This Answer Correct ? | 13 Yes | 8 No |
Post New Answer View All Answers
How network traffic be reduced by using the stored procedure?
Can we use where clause in union?
Write a sql query to sort on different column name according to the parameters passed in the function?
What is indexed view?
What is full outer join in sql server joins?
What are the differences between substr and charindex in sql server.
List the different normalization forms?
Explain transaction server isolation?
Which sql server table is used to hold the stored procedure script?
What are tables in sql server?
How to automatically create a log when an exception is being received into SQL Server?
What is create command?
How to retrieve field values using mssql_result()?
How to scale out a federation by Sql statement?
Can you tell me about the concept of ER diagrams?