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 / sneha s
fetch the 5th record from a table of 10 records:
select * from emp limit 4,1;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What does nvl stand for?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
what is the system function to get the current user's user id? : Sql server database administration
List the data types available in mssql?
what are the different types of SSRS reports?
What new changes are being made in SQL Server?
Can you explain various data region available in ssrs with their use?
What is the difference between locking and multi-versioning?
How do you know if sql server is running on your local system?
How to create a stored procedure with a statement block in ms sql server?
Explain syntax for viewing, dropping and disabling triggers?
How can you check the version of sql server?
Explain different types of Normalization.
Tell me what are cursors and when they are useful?