|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions How we can get the salary whose is earning more than one person and also i want his name also to display...Ex:-If there is 5 members are there who is earning more than the JonesOutput I want is:Jones 2500 hari 2600Jones 2500 king 5000Jones 2500 rakesh 6000Jones 2500 rajesh 6500Jones 2500 ramesh 7000 Read Answers (7) | Asked by : Dinesh 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 ). Select comm from emp; The Null column in the output will come in the last i.e at the end. WHY?e.g COMM 1200 1000 1300 1450 ---- (NULL) ---- (NULL) Latest Answer : SELECT to_char(to_date(24,'J'),'JSP')||' DOLLARS' FROM DUAL ... Read Answers (2) | Asked by : Santosh Latest Answer : We should not use >, >=, = with rownum.It do not show any error message but returns 0 rows.Here select ename,job,salfrom emp where rownum = 2;Rownum always assigns rownum 1 to first row and checks the condition. The condition is false. ... Read Answers (3) | Asked by : surya 1. List all the employees who have atleast one person reporting to them List the employee details if 1. List all the employees who have atleast one person reporting to them List the employee details if and... 2. What is the data type of the column of Dual table? 3. what is a reverse key index and it's real time usage 4. What are the privileges that view does not have as compared to normal table? 5. How to see the existing constraints in a table? 6. how do you generate prime numbers in sql not in plsql 7. What is Local Index and Global Index in Partition Table?What is Prefix Index and Nonprefix Read Answers (1) | Asked by : pradeep 2 Student table Have Following Columns Student_name S1 S2 S3 S4 S5s1 - s5 are subject coulmns. A 87 75 65 77 99 b 34 65 77 88 55write select statement find a Student name ,maximum mark any of the subject s1 - s5output ex A 99 B 88 Read Answers (1) | Asked by : priyanka Using the following Customer, Country and Orders tables: Customer Table c_id c_name c_country_id 1 John 1 Country Table country_id Name 1 US 2 UK Orders Table o_id c_id Qty o_deliver_country_id 1 1 10 1 2 1 20 2 I need the following output in SQLc_id c_name c_country_lives qty o_deliver_country 1 john US 10 US 2 john US Needed a SQL query for this----------I have table with columns firstname, lastname and phone number and we have 2 entries in that table ...now I want to know the persons with this combination firstname Latest Answer : I think you can use the cartesian product on the same table and try to get the data out of that. try this and let me know. ... Read Answers (3) | Asked by : harini How to display & in Oracle SQL output Latest Answer : Use concatenate operator ...SQL> select 'a'||'&'||'b' from dual;'A'---a&b ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0