how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?
Answer Posted / lince thomas
it is simple,
we can get 5th row using this,
select * from (
select rank() over (order by Empid)as rno,* from empmast)T
where T.rno=5
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the difference between Delete and Truncate command in SQL
Define left outer join in sql server joins?
What are the basic functions for master, msdb, model, tempdb databases?
How do I completely remove sql server instance?
What do mean by xml datatype?
Does a sql server 2005 select statement require a from?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to change the system date and time from SQL Plus Terminal ?
How to execute stored procedure in select statement sql server?
Can we join two tables without primary key?
How can we improve performance by using SQL Server profiler?
What do you understand by the data quality services in sql server?
What is updatable resultset?
Explain sql delete command?
what are acid properties? : Sql server database administration