I have student table with fields name,marks1,marks2,marks3 fileds. i want the output as the student details and thier totals and their rank in class, i.e calculated at runtime.please send me the query in sql server or oracle
Hello,I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.ExampleTable having fields like columnA, columnB, columnC, columnD,..........columnN and all have the same dataType. and you dont know in which field your data exists.suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.Is
Subform in ms access having data from linked table to sybase, gives odbc error.my data in of type text. Kindly throw some light. Thanks in advance. Karira, S.
Will the ‘View’ get refreshed immediately when you update a database table. If it doesn’t get refreshed immediately, what method you use to refresh it ?
1. imagine there are 2 tables first table(personal table) consist of : name, age, official address, personal addresssecond table(address table) consist of : street, city, state, phone number, country, zip codeHere personal address and official points to address table1. create the above table2. find and goup the name of the person who lives in same zip code using personal addressIf somebody answer this, it would be a great help.
I have my DB2 database on mainframes and I am trying to replicate the same database on Windows server. I have loaded the table definitions to the Windows servers but looking for a way to export data from Mainframe DB2 tables to Windows server tables (Table definitions in both servers are same).I am looking for an easy and efficient way which can take care of nulls, strings, delimiters etc while exporting.Any help!
I have one teacher table containing school code,teacher details like sex,name etc.I want to count those schools having only male teachers(ie no female teachers).Bcoz corresp to one school there can be multiple records.Its very urgent.Pls help me if somebody has soln?(i need the SQL query full code)
I have small application that i was developing as a school evaluation project,but i have faced problems.(i.e) My command buttons are not perfoming the tasks as expected Edit, and Delete buttons they search and delete the first records on the database. A sample of the commands is as below i am using Using DAO in a module and listviews to display the records.Please helpPrivate Sub cmdEditer_Click()cmdsaved.Caption = "Update"Dim l As Integerl = Val(InputBox("Enter the suppliers Number
If i have 10000 records, My question is now i want to send 1000 records to target each time, how?(source is Flatfile and target is flatfile)
How i can retrieve arabic data using SQL Assistant?because in Teradata admisnitrator i can see arabic data but not using SQL Assistant,is there is any batch should i install??
