how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.
16 19617how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?
6 9584If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
2 7800how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?
TCS,
4 10574There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?
1 5705Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?
4 11111I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu
Adea,
4 5388
Can function return multiple values in sql?
What trigger means?
What is the difference between microsoft access and sql server?
Why do we use subquery?
What is lexical units in pl sql?
Can we call procedure in select statement?
Explian rowid, rownum?
What does (*) mean in sql?
What is Histogram?
Are dml statements autocommit?
What are sql objects?
What does fetching a cursor do?
What are sql triggers used for?
How can you know that statistics should be updated?
Does asenumerable execute the query?