Click here to Skip to main content
15,885,757 members
Home / Discussions / Database
   

Database

 
GeneralRe: Nortwind database selection through database expert ??? Pin
Paul Conrad21-Jul-08 6:13
professionalPaul Conrad21-Jul-08 6:13 
QuestionProblem in a query Pin
Shuaib wasif khan19-Jul-08 23:18
Shuaib wasif khan19-Jul-08 23:18 
AnswerRe: Problem in a query Pin
Colin Angus Mackay20-Jul-08 0:00
Colin Angus Mackay20-Jul-08 0:00 
GeneralRe: Problem in a query Pin
Shuaib wasif khan20-Jul-08 0:54
Shuaib wasif khan20-Jul-08 0:54 
GeneralRe: Problem in a query Pin
Blue_Boy20-Jul-08 2:50
Blue_Boy20-Jul-08 2:50 
GeneralRe: Problem in a query Pin
Shuaib wasif khan20-Jul-08 4:40
Shuaib wasif khan20-Jul-08 4:40 
GeneralRe: Problem in a query Pin
Wendelius20-Jul-08 9:29
mentorWendelius20-Jul-08 9:29 
AnswerRe: Problem in a query Pin
zahedonline21-Jul-08 1:43
zahedonline21-Jul-08 1:43 
Hi Monu Khan,
ZAK here... ya i do understand your problem... But i strongly suggest you to learn atlest basics of SQL and also have handson training before you come to conclusion that you don't know how....

The question you asked is a bignners levfel one.. This time iam answering you.. But remember "The more you learn... The more you grow..."


Creating View:
**************

CREATE VIEW studentView
AS
	SELECT rollno, english, math, history, total/250 AS NetTotal FROM marksheet




Executing View:
***************

Execute studentView



Try this out monu khan

All the best!!!Cool | :cool:

ZAK

Questionloading records problem Pin
harcaype19-Jul-08 16:50
harcaype19-Jul-08 16:50 
AnswerRe: loading records problem Pin
Ashfield20-Jul-08 8:20
Ashfield20-Jul-08 8:20 
QuestionRe: loading records problem Pin
harcaype22-Jul-08 3:28
harcaype22-Jul-08 3:28 
AnswerRe: loading records problem Pin
Ashfield22-Jul-08 8:44
Ashfield22-Jul-08 8:44 
QuestionOne to one Relationship problem Pin
snouto19-Jul-08 6:45
snouto19-Jul-08 6:45 
AnswerRe: One to one Relationship problem Pin
Wendelius19-Jul-08 8:39
mentorWendelius19-Jul-08 8:39 
AnswerRe: One to one Relationship problem Pin
zahedonline21-Jul-08 1:53
zahedonline21-Jul-08 1:53 
AnswerRe: One to one Relationship problem Pin
nelsonpaixao24-Jul-08 12:28
nelsonpaixao24-Jul-08 12:28 
QuestionNeed Arrange Query result into another table Header Pin
rrrriiizz19-Jul-08 1:45
rrrriiizz19-Jul-08 1:45 
AnswerRe: Need Arrange Query result into another table Header Pin
Ashfield20-Jul-08 8:06
Ashfield20-Jul-08 8:06 
GeneralRe: Need Arrange Query result into another table Header Pin
rrrriiizz20-Jul-08 22:54
rrrriiizz20-Jul-08 22:54 
AnswerRe: Need Arrange Query result into another table Header Pin
Mycroft Holmes20-Jul-08 14:47
professionalMycroft Holmes20-Jul-08 14:47 
GeneralRe: Need Arrange Query result into another table Header Pin
Paul Conrad20-Jul-08 14:55
professionalPaul Conrad20-Jul-08 14:55 
GeneralRe: Need Arrange Query result into another table Header Pin
Mycroft Holmes20-Jul-08 15:08
professionalMycroft Holmes20-Jul-08 15:08 
GeneralRe: Need Arrange Query result into another table Header Pin
rrrriiizz20-Jul-08 22:12
rrrriiizz20-Jul-08 22:12 
GeneralRe: Need Arrange Query result into another table Header Pin
Mycroft Holmes20-Jul-08 22:21
professionalMycroft Holmes20-Jul-08 22:21 
AnswerRe: Need Arrange Query result into another table Header Pin
zahedonline21-Jul-08 2:03
zahedonline21-Jul-08 2:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.