 Related Questions Select 1 from dualunionselect 'A' from dual; I guess the query will select zero rows. Is it wrong or right ? if wrong thenWhat will be the result set for the query?Thanks in advance. Read Answers (4) | Asked by : Rachana Latest Answer : Answer: Select * from table_name where rowid in (select max(row_id) from table_name) ... Read Answers (17) | Asked by : A Latest Answer : FOR EXAMPLE TO RETRIEVE 2ND COLUMN(ENAME) IN EMP TABLE:SELECT COLUMN_NAME FROM USER_TAB_COLUMNSWHERE TABLE_NAME ='EMP'AND COLUMN_ID = 2 ... The table name is emp(many fields) with 'designation' as 1 field. my query is i want the percentage of "MANAGERS" in that emp table. (suppose there are 14 rows in total, the rows with 'managers' are 3, so output is (3/14)*100 ). How to select the all first rows which are having same id.for example:id name salary11. suresh 1000011. suresh 1200012. rajesh 1200012. rajesh 13000now i want to get rows as below given format11. suresh 1000012. rajesh 12000 Read Answers (7) | Asked by : sureshkumar When we retrieve data from table in SQL Queries, and want to select second, third,........rows from table, then what is the coding of that program? Read Answers (6) | Asked by : hawasingh How to delete redundant data from a table & How do we come to know that data or rows is being duplicated with same datavalue in Table. Read Answers (5) | Asked by : Neeraj Consider that we r having table name emp....now the question is 1.how should we print the odd rows from that table?2.how should we print the rows where comm=NULL.Reply ASAP Write a query that display the records based on condition. excluding the record that meets the condition Eg... Select all employees who has same salary as empno 20. My query should return all the rows excluding empno20. What is difference between unique index and simple index?is it possible, two rows can have the same unique index? Latest Answer : Unique Index:If the index is for a primary or unique key then the owner, name, type, and columns cannot be modified. These properties are all derived from the key constraint. Changing the name of the key constraint will automatically change the name of ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
