i have three table 1. student (stuid,name) 2. subject (subid,sname,studid) 3. marks (subid,studentid,marks) i want the reslut of how as got max marks in each subject sudentname,max(marks), name abc,70,nikitha
CMC,
1 2952I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
1 4069How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?
2 11488Table1: Col1 col2 1 2 10 3 4 89 5 6 Table:2 Col1 col2 3 2 9 5 4 7 6 87 With the help of table1 and table2 write a query to simulate the fallowing results. Output1: Col1 col2 1 2 2 3 3 4 4 5 5 6 Output2: Col1 col2 2 3 10 4 5 89 6 7 1.Write query for single row to multiple row using sql statements. Eg:a,b,c,d,e,f Change to A B C D E F 2. Write query for multiple row to single row using sql statements. Eg2 A B C D E F Change to Eg:a,b,c,d,e,f Table1: Col1 col2 8 5 2 9 4 2 5 1.Write a query to select all the rows from a table1,if the value of A is null then corresponding B’s value should be printed in A’s value.if the value of A is null in that table then corresponding B’s value should be printed as 30. 2. write a query to find the sum of A and B .display the max among both. 3.write a query to find total number of rows from table 1. Note: if any column value is null in a row then that row should be considered as 2 rows. 4.write a query to display all the records of table1 except A containg 2 as well B containg 5. 5.rewrite the fallowing without using join and group by. Select b.title,max(bc.returneddate –bc.checkoutdate)” mostdaysout” From bookshelf_checkout bc, Book shelf B Where bc.title(+)=b.title Group by b.title. 6.rewrite fallowing query Select id_category from category_master X where exists (select 1 from sub_category Y where X.id_category=Y.id_category) Customer: Name phone1 phone2 phone3 bitwise A 23456 67890 12345 --- B 67459 89760 37689 --- Don’t_call Col1 67890 37689 1.q) update the customer table of bitwise with 1 or 0. Exists in don’t_call table menas show -1 Other wise -0. Output. Name bitwise A 010 B 010
2020How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
1926How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
2 5714how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
TCS,
1918how can we send a concurrent program output to the clients through mail or fax give me example.
1 5039
How to add a new column to an existing table with a default value?
where the connection string store in the database
How can we delete duplicate rows in a table?
What is difference between mysql and mariadb?
Which version of open client works with which ase in sybase?
How do indexes help, types?
Tell me extended events in sql server 2008?
What is create command?
explain what is mysql? : Sql dba
What is data type in sql?
What are the different types of replication are there in sql server 2000?
What is service based database?
System requirements for sql server 2005 express edition?
What is data modelling in sql?
What are field types?