Interested to Buy Any Domain ? << Click Here >> for more details...
how u can find the n row from a table?
- 19 Answers
- 30150 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / guest
select rownum,ename,sal,empno from(select ename,sal,empno from
table_name order by sal) group by rownum,ename,sal,empno
having rownum=(select count(*) from table_name
| Is This Answer Correct ? | 10 Yes | 13 No |
Post New Answer View All Answers
What are the two characteristics of a primary key?
describe transaction-safe table types in mysql : sql dba
Why sql query is slow?
What is primary key and foreign key?
What does sql stand for?
Why is stored procedure faster than query?
What are the operators used in select statements?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How many types of functions are there in sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
How can we make an if statement within a select statement?
what are dynamic queries in t-sql? : Transact sql
What is dml and ddl?
What is sql partition function?
What is the trigger in sql?
