How to obtain employees who earn sal greater than avg sal in the given deptment in classic emp, dept tables
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
For example In my table one datetime field example modified_date_time.its displaying 2006-08-18 23:28:23 (here its rounding seconds)But I want the format like 2006-08-18 23:28:22.123456 (I want the absolute
Latest Answer: You can use like the followingSELECT TO_CHAR(systimestamp,'yyyy-mm-dd HH24:mi:ss.FF') FROM DUAL;which gives you like 2007-08-23 14:12:36.769726 ...
Latest Answer: NOT NULL: It allows duplicates, but doesn't allow null valuesUNIQUE: It allows null values, but doesn't allow duplicatesPRIMARY KEY: It doesn't allows duplicates and null valuesUnique index wil be created automatically for PRIMARY KEY, ...
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
Latest Answer: NVL is a built in function provided by oracle which accepts two parameters. NVL function returns the first parameter if the first parameter is not null and it returns the second parameter if the first parameter is null.select emp_no, nvl(comm_prt,0) ...
I think there can be only one null value for a unique key constraint but some say there can be more than one null value.
Latest Answer: Can have any number of NULL values, since oracle maintains internally different values for each NULL values. ...
Latest Answer: you can use sum functionselect sum(sal) from emp; ...
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
